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