One of our customers has gotten an error while using Excel 2003 and from Notes using LotusScript-code which says xlapp.DisplayAlerts.
“The property DisplayAlerts is not applicable for the application-class” is the error-message at hand but I don’t have a clue on how to solve it and we don’t have Excel 2003 to try on so any tips are very welcome.
I’ll make a guess that your OLE code was written for a different version of Excel and 2003 doesn’t use the DisplayAlerts method. MS periodically modifies the way OLE works and stuff just stops working - oh the joy!
Some ideas:
Buy and install 2003 and debug the problem.
Visit the customer, take a developer client with you and debug on site since they have 2003.
Go to any of the VBA/Excel forums and see what you can find - OLE belongs to MS so those forums are good places to go for help.
Hope someone has specific information on the issue.