Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
Excel Automation - How to eliminate warning messages?
Versions des environnements
I want to do the following:
1) Export a XLS file from a VFP database.
2) Load the new XLS file into Excel using CREATEOBJECT("Excel.Application")
3) Save the application so that it will convert from the older version of Excel (from the export) to a later version (Excel 97).
However, I have to manually select "Yes" from the questions "Do you want to save the file?" and "Do you want to change the format?"
It there a way to eliminate these warning questions and just autaomatically save the file using Office (Excel) Automation?
Thanks,
Robert
PS: The reason I want to use the export feature of VFP is because it is so much faster than writting the records out one at a time.
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