Mac Excel versus Windows Excel?

**IanWade** · 12-09-2011, 02:20 AM

I have written and tested a VBA program that works fine under various versions of Windows Excel. But someone is now trying to run it under Mac Excel (specifically version 14.1.3) and is getting some syntax errors. Before I dig deeper, is there anything I should know that makes Mac Excel different from Windows Excel?

--
Ian

**romperstomper** · 12-09-2011, 06:40 AM

Excel 2011 does at last have VBA6, but there are some differences still. Things like the Find method do not have all the same arguments (can't find formats, IIRC) and there are other quirks. Also, of course, you can't use windows API calls or ActiveX.

**IanWade** · 12-09-2011, 05:44 PM

Originally Posted by romperstomper

Also, of course, you can't use windows API calls.

Of course, I hadn't thought of that! So obvious.

So I will now have to tell my user that my program will never run in Mac Excel.

Thanks

--
Ian

**jaslake** · 12-09-2011, 07:47 PM

Hi Ian
This may well be true

I will now have to tell my user that my program will never run in Mac Excel

but there are relatively inexpensive solutions such as VMWare Fusion and Parallels that allow you to run "Virtual Machines" on the Mac. I personally use VMWare Fusion and it works just fine...have no issues running PC based Macros on the Mac. You do of course have the additional expense of licensed versions of Office.