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