Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Excel Automation - How to eliminate warning messages?
Message
De
31/01/2011 02:07:32
 
 
À
31/01/2011 00:22:17
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP
Network:
Windows NT
Database:
MS SQL Server
Application:
Desktop
Divers
Thread ID:
01497891
Message ID:
01497894
Vues:
90
loExcel.DisplayAlerts= .F.
>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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform