[Budweiser]

I've recently moved from a PC to a Powerbook G4 and the VBA code in one of my Excel spreadsheets no longer works.

The code:

Dim A
Set A = CreateObject("Scripting.Dictionary")

returns the error:

ActiveX component can't create object


I've tried creating a blank workbook with just this code, but get the same error. This works fine in Excel for Windows.

Any thoughts?

[Maflynn]

My guess is the object has not been defined in excel for the mac, there are other objects (none come to mind right now) that I ran into when moving my spreadsheets/vba macros to the Mac.

Mike

[Budweiser]

Any way of importing the object?

[Maflynn]

Originally posted by Budweiser:
Any way of importing the object?

If you have access to a PC, take a look at references within the VB editor, that is Tools-> References. Perhaps its as simple as the object not being selected for the Mac flavor.

Mike

[Shades of Gray]

ActiveX is not supported on the Mac side (thumbs down to MS).

I have done testing/consulting for cross-platform integration of VBA solutions, and this is one of several that cause problems. One alternative is to use Forms rather than Control toolbox to create the object. Also, several of the References (Tools > Reference) in VBA are not available for the Mac. Likwise, if you need ODBC support, you will have to look at third-party solutions. Yep, MS provides free ODBC for Windows, but not for Macs. If you need I can give you couple of links.

[larkost]

Just to be exact, the ODBC layer is very much present on MacOS X. The problem is that there is a scarcity of ODBC drivers for the big DB's out there on MacOS X. This is starting to change, but the changes are new enough that people still have the old impression.

[Shades of Gray]

Yep, you're correct. I had been in a hurry and hadn't specified that it was the drivers. Thanks.