>>>>Hi,
>>>>
>>>>Whenever I export a file from VFP 9 application (either using EXPORT TO or Createobject("Excel.Application")) and then open the resulting Excel file, I get the message (as shown in the attached image). Then, when I click on Yes (that is to open it anyway), I don't seem to see any problems with the Excel file content?
>>>>Why then MS Excel shows this message?
>>>>TIA
>>>
>>>I believe you'll see this is you EXPORT with TYPE XLS. Similarly, make sure you're choosing an appropriate format when you save the file via Automation. There's a parameter for SaveAs that lets you specify the format you want. If you're creating an XLSX file, give it that extension.
>>>
>>>Tamar
>>
>>As far as EXPORT to, I changed the type to XL5 (as you suggested).
>>
>>And as far as saving as XLSX with SaveAs, would the customer who has an older version of Excel (e.g. 2003) have a problem opening the .XLSX file?
>>
>
>Yes. So use an older version and just make sure you specify which one you want in SaveAs. I'd go with the latest version that isn't XLSX.
>
>Tamar
Thank you. This is what I will do; leave as it is (EXPORT TO TYPE XL5)
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham