CreateObject and OLE Support on Mac

HCL Domino Domino Forum
1

Hi,

the following lotusscript code doesn’t work on Mac with the message “Operation not supported on this platform”:

Set Excel = CreateObject( “Excel.Application” )

Excel.Visible = True Excel.Workbooks.Add Set xlWorkbook = Excel.ActiveWorkbook

Set xlSheet = xlWorkbook.ActiveSheet

I have read that CreateObject is supported on the Macintosh as long as

OLE support is installed.

How can I install OLE support on Macintosh?

Best Regards,

Monika

2

Subject: I’m not aware of any OLE support on the (modern) Mac

MS does support AppleScript though; if this helps…:VBA to AppleScript Transition Guide

3

Subject: CreateObject and OLE Support on Mac

Hi Monika,

Did you ever find a solution for your OLE issue? I have OLE Support installed on OSX 10.6.4 and Office 11, but I also get the error message “Operation not supported on this platform” when I try to use CreateObject.

Thanks,

Dieter