Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel automation
Message
From
10/02/2004 08:15:40
 
 
To
09/02/2004 15:30:45
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00875617
Message ID:
00875840
Views:
17
>I am doing ole with fox to automate excel. Everything is fine until the user make some change and don't apply the change to the cell (doing enter key or mouse click on the green arrow or on the red X to confirm the change).When this append any code doing ole with excel hang waiting for Excel reply.
>
>I must find how to tell to Excel to apply the change before doing anything else. I am searching in activecell, activeworkbooks ............
oExcel.DisplayAlerts = .F.
This should avoid (ignore) Excel prompts. I use it when saving, to avoid Excel's prompt "do you want to save xxx?" It would probably do what you want.


Alex Feldstein, MCP, Microsoft MVP
VFP Tips: English - Spanish
Website - Blog - Photo Gallery


"Once again, we come to the Holiday Season, a deeply religious time that each of us observes, in his own way, by going to the mall of his choice." -- Dave Barry
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform