>>>>>Does any know of a program that can convert xslx to xls (capable of being imported VFP) that can be run in batch mode
>>>>
>>>>Are you able to use Excel itself? You can programmatically automate Excel from VFP, and instruct it to SaveAs an earlier version.
>>>>
>>>>Of course, if you do have the option to automate Excel then you can access the contents of .xlsx files directly without having to use the VFP import function.
>>>
>>>Al
>>>
>>>Thanks for the answer - yesy I can use Excel - how do I programmatically automate Excel from VFP, and instruct it to SaveAs an earlier version?
>>>
>>
>>
>>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?
Yes, except that I have a mistake in the 3rd line. It should be SaveAs rather than Save. Plus, you'll want to specify the file with the XLSX extension in the 2nd line.
Tamar