>>>>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?
Specialist in Advertising, Marketing, especially Direct Marketing
I run courses in Business Management and Marketing