Q: Microsoft Office Visual Basic issue after upgrade to MacBook Pro via Migration Assistant
I've just moved all my files from my old iMac to my new (well new to me - it's a second-hand 2010 2.4 GHz 13 inch model) MacBook Pro using Migration Assistant. Everything worked flawlessly apart from one thing - whenever I try and use a macro now in MS Office 2011 I get the following message:
*****
Can't load Visual Basic for Applications
Make sure Visual Basic for Applications is installed on your computer. if Visual
Basic for Applications is installed, make sure the path to the installation
folder does not contain any characters outside of the system code page (such as
Cyrillic characters on an English system) and contains fewer than 255
characters.
*****
Visual basic worked perfectly before on my old iMac, so I have no idea what has happened here to throw it out. VBA is installed, and the path is:
"MBP/Applications/Microsoft Office 2011/Office/Visual Basic for Applications.framework/Visual Basic for Applications"
so no strange characters and well under 255 characters too.
From the error message it seems all I have to do is tell Word where to look to find the program and it will be happy, but in typical Microsoft fashion the error tells me what's wrong but not where to go to fix it or how. There's nothing obvious in Word under Preferences>File locations, and I've tried reinstalling just Visual Basic for Applications from the Office 2011 DVD but that didn't change anything either - same error message and the files are in the same place on my hard drive. I'm loathe to entirely reinstall office to fix what appears to be a relatively simple issue as I'll have to set it up from scratch again. Does anyone know where/what I have to do to point Word in the right direction?
Both the iMac and the MacBook are on Mountain Lion, and the transfer worked perfectly otherwise. I can't find anyone else having had this issue after an upgrade using Migration Assistant, so any help gratefully recieved!
G.
Posted on Apr 8, 2013 8:12 AM
Used Mavericks migration asstant to move to a new MacBook Pro 7 days ago and Word became unusable with Dragon Dictate for Mac with the 'Can't load Visual Basic for Applications' message.
After talking to the nice people at Apple support, they suggested calling the Microsoft Mac team- who wanted £65 to talk to me. Decided, with Pages installed, that Word wasn't worth the money to me, so politely declined and went back to the forums and worked through the suggestions to delete the preferences, run the updates again, using Font book to repair fonts & co
Tried the 'rename the HD to the same as the original' suggestion without sucess-
The only thing that worked for me was to reinstall Office from the disk image. Painless -- and the reinstalation preserved my registration and templates. Only problem was locating my copy of the disk image!
Posted on Nov 9, 2013 8:29 AM