OLE Support on OSX

HCL Domino Domino Forum
1

I am trying to run OLE automation apps which have been developed under Windows on the OSX platform - OSX 10.6.4 and Office 11. OLE Support is installed as well.

However, I am getting the error message “Operation not supported on this platform” when I try to use CreateObject to start Excel and populate an Excel sheet.

Here is the code I am trying to use:

Dim xxlApp As Variant  'Excel.Application

Dim xxlBook As Variant  'Excel.Workbook

Dim xxlSheet As Variant  'Excel.Worksheet

Set xxlApp = CreateObject("Excel.Application")

Set xxlBook = xxlApp.Workbooks.Add

Set xxlSheet = xxlBook.Worksheets(1)

Has somebody successfully used OLE automation under OSX?

Thank you,

Dieter

2

Subject: OLE is not supported on Mac & Linux.

3

Subject: OLE Support on OSX

This is from the Domino 8.5 Help:

CreateObject function

Creates an OLE Automation object of the specified class.

Note CreateObject is not supported under OS/2 or UNIX. It is supported on the Macintosh as long as OLE support is installed.

OLE Support is installed on my Mac. So … shouldn’t it work?

  • Dieter