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!
Fi69Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

byundtMechanical EngineerCommented:
I use a Mac, but spend most of my day using Excel for Windows. I do this using Parallels virtual machine, which is much faster than Virtual PC ever was. I also use Word for Windows. Both Word and Excel are pretty snappy on my 2008 MacBook Pro, even running macros--and I'm a power user.

To follow this approach, you will need to install Parallels (or VMware), a licensed version of Windows and a licensed version of Office. The benefit of this (as opposed to using BootCamp, which is free from Apple, a licensed version of Windows, and a licensed version of Office), is that you can switch between Mac and Windows apps very easily.

Both Parallels and VMware update their Mac products every year (and have just done so).

Note that you may also want to budget for a Windows antivirus program if you take that approach.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Chris BottomleySoftware Quality Lead EngineerCommented:
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
0
Fi69Author Commented:
Thanks byundt. I took your advice and installed Parallels, Windows & Office and have tested the macros and it works perfectly! Thank you.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Development

From novice to tech pro — start learning today.