Excel 2003 and DisplayAlerts

Hello,

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.

Thanks in advance

Subject: Excel 2003 and DisplayAlerts

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.

Doug