>>We have a number of places in our system where we do something like
>>COPY TO (lcFileName) XLS
>>oxl = CREATEOBJECT("Excel.application")
>>oxl.displayalerts = .F.
>>lcFileName = "something"
>>oxl.workbooks.open(lcFileName)
>>
>>do stuff
>>
>>oxl.save()
>>
>>We now have a mixture of machines with Excel 2007 and older versions of Excel. The 2007 machines are now opening a dialog box asking for a filename to save in XLSX format.
>>
>>I've resolved that issue (perhaps not in the best way - but it seems to work) by re-coding the Save() command as
>>oxl.activeWorkbook.saveAs(lcfilename,39)
>>
>>We have a situation, however, where a subroutine has received the Excel object as a parameter. This subroutine performs a save operation. In order to convert to the new save process I need to know the filename.
>>
>>While I could modify the routines to pass the name of the file, it seems more generic to get the name from the Excel object itself (if possible)
>>oxl.activeworkbook.name
will give me the file name, but without the complete path.
>>
>>Is there some other property/method I can use to get the complete file name?
>
>Try the Fullname property.
>>
>>Is there an alternate way of saving the file without getting the SaveAs dialog box?
>
>Would setting DisplayAlerts to .F. do the trick?
>
>Tamar
DisplayAlerts is already set to .F.
Fullname does the trick.
Thank You Tamar