How To Determine FileFormat Values for Excel SaveAs Method

MORE INFORMATION

1. Create a worksheet in Excel and save it in the format that you want. Make sure that you close the file before continuing.
2. Issue the following commands in Visual FoxPro:

         * First get an object reference to the Excel application
         oXL = CREATEOBJECT("Excel.Application")  && starts excel
   
         * Open the worksheet created in step 1 (be sure to include
         * the full path and file name
         oXL.WorkBooks.Add("myfile.xls")
   
         * Retrieve the FileFormat
         nFileFormat = oXL.WorkBooks(1).FileFormat
   
         * Save the file under a new name with the same format
         oXL.WorkBooks(1).SaveAs("new.xls",nFileFormat)
   
         * Quit Excel
         oXL.Quit
   
         * Release the object reference
         RELEASE oXL