breadbin

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

Close

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

  • All replies
  • Helpful answers

first Previous Page 3 of 3
  • by PhotoBrazil,

    PhotoBrazil PhotoBrazil Jun 2, 2016 5:56 AM in response to breadbin
    Level 1 (4 points)
    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.

  • by apalca,

    apalca apalca Jul 15, 2016 6:35 AM in response to motorcyclespeedcop
    Level 1 (4 points)
    Jul 15, 2016 6:35 AM in response to motorcyclespeedcop

    I tried several other suggestions but only this worked for me.

     

    Maybe VB won't work anymore now? Not that I care, I just use Word to access docs others send me. But I hated this stupid error message (with several formatting/spelling errors too) so I'm very happy it's gone.

     

    Thank you motorcyclespeedcop!

  • by GreenTeaNYC,

    GreenTeaNYC GreenTeaNYC Jul 25, 2016 9:19 AM in response to motorcyclespeedcop
    Level 1 (4 points)
    Jul 25, 2016 9:19 AM in response to motorcyclespeedcop

    This worked for me.  Thanks!!!

  • by sjallyn,

    sjallyn sjallyn Jul 31, 2016 10:33 AM in response to motorcyclespeedcop
    Level 1 (4 points)
    Jul 31, 2016 10:33 AM in response to motorcyclespeedcop

    Perfect, on.y wish I found this faster and sooner.

    Works, no re-install nothing.  Just dump that folder.

    Thanks

  • by jnl500,

    jnl500 jnl500 Aug 15, 2016 7:13 PM in response to breadbin
    Level 1 (9 points)
    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.

  • by Abiola O,

    Abiola O Abiola O Aug 22, 2016 3:30 PM in response to jnl500
    Level 1 (4 points)
    Aug 22, 2016 3:30 PM in response to jnl500

    Fantastic! I tried other suggestions but this is the only one that worked.

    Thanks

first Previous Page 3 of 3