I have an application running on Windows, and now some of my users are starting to use MACs. The export to excel agent works fine on Windows, but fails on the very first reference to Excel
Set xlApp = CreateObject(“Excel.Application”)
The error message is Error 180: Operation not supported on this platform.
Microsoft Office 2011 Version 14.5.3 is installed on the Mac Pro.
The CreateObject function (LotusScript Language) help says: Creates an OLE Automation object of the specified class. Note: CreateObject is not supported under OS/2 or UNIX.
No mention of an exception on Macintosh.
Any ideas?
Subject: what Carl said but…
Excel files are XML files now. You can create XML files in your agent using LotusScript or Java. Or, if using Java, you can Apache POI to help in the creation of the Excel file. We have examples of this in our Java 2 for XPages course at www.tlcc.com <>. What we do there would also work in a regular Notes Java agent too or you could just point them to a url that runs an XPage that generated the Excel file.
So, to support the Macs you would need a new approach.
Howard
Subject: Macintosh doesn’t have OLE automation
Probably IBM never updated that documentation, as the Mac version didn’t exist at the time it was written.