ActiveX Data object for MacBook

Question

I have purchased Ms Office, and installed in my MacBook Air. I can not run VB enabled Excel file (that runs perfectly fine in my Windows Laptop) as it misses 'Microsoft ActiveX Data objects 2.1 Library'. Please advise how to install it in MacBook Air.

I tried to take out the 'Missing: ActiveX...' from References, but then there was new error. In short, this ActiveX library must be installed to run the file.

The error message is 'Compile Error: Can't find project or library' when I run the file. Please HELP.

Thanks.

Answer 1

ActiveX is not supported on OS X. AFAIK, the only options are to;

1. Modify the code if possible using an alternative to ActiveX as well as revamping other potential incompatible/Windows-specific code, or
2. Install Windows & Office for Windows on your Mac in a Boot Camp partition or on a virtual machine using either Parallels or VMware Fusion.

It would also be recommendable to test thoroughly before making the additional investment... There may be some code that won't function properly in a VM.

Answer 2

FYI Bob, I have never found anything that runs in Windows that does not run in Parallels.

Answer 3

Hi All,

The same issue I am getting and have posted my concern in the MS community.

http://answers.microsoft.com/en-us/mac/forum/macoffice2016-macstart/excel-vba-on-mac/dbe2de0f-6feb-4b70-a24e-e5bcdb155205?msgId=bc081b08-9608-48dd-a864-e6a15d120d43

Answer 4

Good to know! I'd heard comments from others suggesting possible errors with hardware-related code, but have no specifics or personal experience to confirm/deny those claims.