>>>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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement