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.
oxl.activeWorkbook.saveAs(lcfilename,39) && save in XLS formatWe 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.
oxl.activeworkbook.name
will give me the file name, but without the complete path.