Automation error in vba

Hello

I am trying to run the dashboard on a client's Mac. However, i keep getting the following error everytime i click on Refresh.

"Runtime error '-2147483640 (80000008)': Automation Error in mac excel"

The code is working on a Windows laptop. Password for the code is "sahilkh18".

Please help.

Originally Posted by sahilkh18

Hello

I am trying to run the dashboard on a client's Mac.

[facetiousness on]

There's your problem.

[facetiousness off]



Which line of code does it error on?

I know, but he does not have any other system. So this is the only option.

Any thoughts on how to make the codes work?

I am not sure, because I am not able to debug the code even on his system. It does not let me open the debugger.

I found some articles online which suggested changing the dates and putting the country as US. However, that also did not work.

You've got no chance. If you can't even see the code on his system there is absolutely no possibility of figuring out what's causing it to crash. If this was 1984 I'd tell the client if he wants to run business applications then he should have bought a machine made by 'International Business Machines'.....not a fruit farm.