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

Jun 7, 2015 5:11 AM in response to breadbin

Here is how I solved the problem:

  1. Close MS Word and Dragon.
  2. Launch the MS Office installer.
  3. On the "Installation Type" screen, click "Customize".
  4. Expand "Microsoft Office 2011".
  5. Uncheck "Visual Basic for Applications" and leave everything else as it is.
  6. Proceed through the rest of the installer.
  7. Repeat steps 2-6, but in step (5), re-check "Visual Basic for Applications".


Dragon Dictate should now work again with Microsoft Word.

Dec 21, 2015 5:51 PM in response to breadbin

Possible fix for message: Can't load Visual Basic for Applications, Macbook Pro Retina, Running El Capitan, Mac Office 2011.


Trawled through dozens of posts before I decided to have a look through the Microsoft Office 2011 Folder:


Go to Applications:


Open MS Office 2011 folder,


Then open folder named, Office.


This folder has a myriad of folders and information including subfolders called Add-ins, Help, Media, etc. Amongst these folders is one called 'Startup'.

This folder appears to have nothing in it except a simple startup protocol that insists Word start by questioning the whereabouts of VB. Delete this folder to the trash. Close Word then open it up and the message should go.


Let me know how it works out.


Cheers.

Jan 26, 2016 10:42 AM in response to mjlee

I never got a reply to my question, so I ended up installing Office 365. I already had a 2-person subscription to Office 365, which I was using on my Windows 10 PC, but I was reluctant to do the upgrade on my mac, afraid it would mess things up.


But the Office 365 install seemed to work ok. And the advantage is that now, all my devices are on OneDrive so I can access/edit excel and word docs from iOS, Windows, and Mac (El Capitan).

Jun 2, 2016 5:56 AM in response to breadbin

This solve my problem. Thanks for motorcyclespeedcop

-----------

Possible fix for message: Can't load Visual Basic for Applications, Macbook Pro Retina, Running El Capitan, Mac Office 2011.


Trawled through dozens of posts before I decided to have a look through the Microsoft Office 2011 Folder:


Go to Applications:


Open MS Office 2011 folder,


Then open folder named, Office.


This folder has a myriad of folders and information including subfolders called Add-ins, Help, Media, etc. Amongst these folders is one called 'Startup'.

This folder appears to have nothing in it except a simple startup protocol that insists Word start by questioning the whereabouts of VB. Delete this folder to the trash. Close Word then open it up and the message should go.

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.