For the Mac Run-time error 429 ActiveX component can't create object

Is there a compatible VB code for Mac and PC? The below code works fine for the PC users, but not for Mac users. Here is the command that is failing (debug results): Set OutlookApp = CreateObject("Outlook.Application") Mac user is running on version 14.2.5

Please Login or Register  to view this content.

Any help is greatly appriecated, I have read through http://www.rondebruin.nl/mail/folder3/filelink.htm and didnt' note any compatible codes.

I don't think ActiveX is available on a Mac, so you have to find some other way around this - I discovered this when I had used an ActiveX button on a PC to run a macro and it would not work on a Mac, so I had to change it to a Forms button.

Hope this helps.

Pete

Worked out great. Created one form button for PC users and another for Mac Users. Had to use different VB codes but got the end result I wanted.


Problem solved

Hi Jsalisbury,Can you please share your code how you converted your code for MAC.I am having same problem my code works on win 10 but doesnt work on MAC.please help.

Please note that the thread is 9 years old - I doubt if the OP is still listening.

Pete