AUTOMATION ERROR on MAC that work perfectly in Windows

**LuisAntonio** · 12-22-2019, 06:57 PM

Hello partners.

I developed a macro in MS Excel 2016 for a client that uses MAC, the macro works perfectly in Windows, however, when it is executed in MAC it does not work and what is worse: It only shows a useless message "Microsoft Windows Visual Basic Automation Error" .

I use Option Explicit in my code

Do any of you know what could be the cause of this error?

**shg** · 12-22-2019, 07:23 PM

Duplicate post: https://www.excelforum.com/excel-pro...n-windows.html

Please don't do that.

**alansidman** · 12-22-2019, 09:38 PM

Administrative Note:

Welcome to the forum.

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #5 about thread duplication.

I am closing this thread, but you may continue here in the original thread