Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel DisplayAlerts
Message
From
05/07/2011 14:41:57
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
Excel DisplayAlerts
Environment versions
Visual FoxPro:
VFP 8 SP1
Miscellaneous
Thread ID:
01517330
Message ID:
01517330
Views:
122
Hi All:

We have been using Excel automation for quite some time but I've run into something I haven't seen before. Creating an instance of Excel is always done via
oxl = CREATEOBJECT("excel.application")
oxl.displayalerts = .F.
In our current situation we are processing a series of spreadsheets in a folder. When I open a particular spreadsheet DISPLAYALERTS suddenly switches to .T.

It happens every time I open this particular spreadsheet.

Is there anything I can check in the spreadsheet to see what is causing the setting to change?

Thanks to all.............Rich
Next
Reply
Map
View

Click here to load this message in the networking platform