>>>>We have a number of applications which do something like.....

>>>>DO something  --> creates a result cursor
>>>>COPY TO myFile XLS
>>>>oxl = CREATEOBJECT("Excel.application")
>>>>oxl.Open(myFile.xls)
>>>>oxl.save()
>>>>oxl.quit
>>>>oxl = .null.

>>>>
>>>>We've (finally) started the migration to Excel 2007 and the SAVE command is causing us some problems. It is popping up a dialog box asking for a file name and providing an XLSX extension. This is an annoyance to the casual user, but is a real problem for those programs which run unattended.
>>>>
>>>>1. Is there a global setting in Excel that will save a file in the format in which it was created? With a limited number of users using a newer version, it seems easier to do this than find and recompile all the modules which are affected.
>>>>
>>>>2. Is there some parameter in SaveAs() that could be passed to accomplish the same result? This parameter would have to be downwardly compatible so that it works with users who have not been upgraded.
>>>>
>>>>3. What alternative suggestions do you have for resolving the issue.
>>>>
>>>>Thanks...............Rich
>>>
>>>Check SaveAs() VBA method. There you could set the format you want to use.
>>>Also set oExcel.DisplayAlerts = .f. if you don't want alerts to be shown.
>>
>>This is what I'm doing. I included some some of the defines (contained in Excel.h) so you can see other format possibilities.
>>
>>

>>#DEFINE xlExcel3            29
>>#DEFINE xlExcel4            33
>>#DEFINE xlExcel4Workbook    35
>>#DEFINE xlExcel5            39
>>#DEFINE xlExcel7            39
>>#DEFINE xlExcel9795         43
>>#DEFINE xlExcel8            56
>>#DEFINE xlOpenXMLWorkbook   51
>>.
>>.
>>goExcel.ActiveWorkbook.Saveas( scOutput_file_name, xlExcel9795 )
>>.
>>.
>>

>
>Thanks Scott,
>But the question was asked by Rich :-)

I noticed that right after I clicked Send. It did keep the thread linear though, none of those confusing in and out, back and forth, up and down, whatever, posts.