Apple Event: May 7th at 7 am PT

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

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

Reply
36 replies

Aug 15, 2016 7:13 PM in response to breadbin

I fixed this by deleting this file:

/Applications/Microsoft Office 2011/Office/Startup/Word/linkCreation.dotm


This is an add-in from Adobe that adds a command to launch Adobe Acrobat to Word's File menu. It is completely unnecessary and poorly written so it always breaks as updates happen.


Google "linkCreation.dotm" for more details on the myriad ways Adobe breaks people's Word installations.

Microsoft Office Visual Basic issue after upgrade to MacBook Pro via Migration Assistant

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.