Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel Automation - How to eliminate warning messages?
Message
From
31/01/2011 02:07:32
 
 
To
31/01/2011 00:22:17
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP
Network:
Windows NT
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01497891
Message ID:
01497894
Views:
89
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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform