>>
>>oXL = CreateObject("Excel.Application")
>>oXL.Workbooks.Open("YourFile.XLS")
>>oXL.ActiveWorkbook.Save("YourFile", nDesiredFormat)
>>oXL.Quit()
>
>
>>
>>
>>Use 56 for Excel 97 format. That said, I don't think newer versions can actually produce an Excel 97 format that VFP can read. You have to go back to Excel 5 format for that to work; I think the constant you want is 39.
>>
>>Tamar
>
>
>Tamar
>
>I don't understand - the file I am trying to convert is an xslx file to xls file - will your code do that?
It should - just use xlsx as extension in the sample. Why you don't want to try that code first to test?
If it's not broken, fix it until it is.
My Blog