asked on

Heavily VBA coded Word template setup on PC - best way to get it to run smoothly on a Mac

Hi experts.

I have a heavily VBA coded Word 2010 template. It is setup on PC. It calls dialog boxes, inserts data from Excel, etc. etc.

One of my users now has a Mac, running Microsoft Office for Mac 2011, but they get error codes galore when accessing any of the macros.

Is there an easy solution to this problem? For instance if you installed something like Virtual PC for Mac, would that resolve the issue? And is so, how does that work, do you install Virtual PC for Mac and then you install the Windows version of office????

Love some advice!

ASKER CERTIFIED SOLUTION

byundt

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Chris Bottomley

I used to use Parallels to run Windows in a virtual machine but with lots of low level macros accessing PC resources a significant number of them gave me issues. It may be that this was a lack of knowledge on my part but I now run a PC as well where I can produce and maintain macros so my own experience is that if your template uses low level resources then it is at risk. Relatively simple macros which do not use such resources may be convertible ... for example file paths can be assembled using Application.PathSeparator rather than the forward/backward slash explicit character.

Chris

Fi69

ASKER

Thanks byundt. I took your advice and installed Parallels, Windows & Office and have tested the macros and it works perfectly! Thank you.