Office 2011 - Can't Find Visual Basic for Applications Error

Question

Level 1

4 points

Office 2011 - Can't Find Visual Basic for Applications Error

I have recently installed Microsoft Office 2011 on my Mac and have been using the Dev tools to program macros in VB. Suddenly, it stopped loading it when I try to enter the VB workspace and throws an error stating that "Can't Find Visual Basic for Applications." The error tries to be helpful, but in a typical Microsoft way is just plain vague. Any thoughts?

MacBook Pro (Mid-2009 Unibody)/iMac/PowerMac G4 Cube/IBM ThinkPad T43/iPhone 4, Mac OS X (10.6.6), OSX Tiger Server/OSX Snow Leopard/iOS 4.2/Windows 7 Ultimate

Posted on Feb 8, 2011 12:28 PM

Reply

Answer 1

Holger_S

Level 1

0 points

Mar 9, 2011 12:11 PM in response to admiralkymia

Hello,

I have same problem here...

My system MacPro 2009 Quadcore 2,66 - 6 GB RAM - OS X 10.6.6, HD WD 640 GB Black is formated with GUID partitiontable, Mac OS Extended (Journaled).

I bought MS Office 2011, installed. It works fine - but no VBA is available, Macro recorder does not work and VBA Editor can not be opened.

I did do a clean install, new user - than MS Office 2011 installed. Same problem. Microsoft is informed, case id openend. They do not have a solution at the moment for this bug...

So, any ideas?

Thank you

Holger_S

...I am sorry, I am not a native speaker.

Reply

Answer 2

Holger_S

Level 1

0 points

Mar 11, 2011 7:24 AM in response to Holger_S

Problem is solved. Hard Drive name included a special sign (" ^ "), after clean install and renamed Hard Drive it works fine.

Mac Office 2004 and 2008 worked with old name of my Hard Drive fine, only 2011 was in trouble.

Reply

Answer 3

teep

Level 1

10 points

May 30, 2011 2:48 PM in response to Holger_S

I have the same problem, but have no odd characters in my hard disc name.

I am pteey annoyed as I bought Office 2011 pre-loaded on my new Macbook, but it did not have the VBA (which is why I wanted Offfcie rather than the free OpenOffice in the first place).

VBA is supposedly on the Office distrbution CD, so I went through the loop of re-installing Office 2011 with the VBA option ticked. No VBA apperared. After 3 times trying the install, still no VBA. The macbook has the VBA framework file installed in the applications folder, but the clicking the editor tab in the developer tab of Excel just brings up an error massage sayng VBA is not installed.

Not clear where to go from here. Try the Genious Bar at the local mac store?

Reply

Answer 4

oldjay

Level 1

0 points

Jun 21, 2011 6:57 PM in response to admiralkymia

Have office 2011. Can run VBA script from editor but can't run from command buttons. How do I activate command buttons?

Reply

Answer 5

worksafe

Level 2

180 points

Jun 21, 2011 8:01 PM in response to admiralkymia

I run Office 2011 but don't experiment as much as you folks do but I do use http://www.officeformac.com/productforums/ if I have a problem with the suite.

Reply

Answer 6

Sep 9, 2011 11:42 AM in response to Holger_S

Hi,

My hard drive name included my first name "François". When I changed it to "Francois", VBA worked immediatly, with no need for reinstall anything.

Just amazing and crazy!

Reply

Answer 7

serfu

Level 1

0 points

Aug 19, 2013 8:16 AM in response to FrançoisExplorateur

It's unbelievable...I have been trying for months to fix this problem, in several sites and forums, and your answer was the best! My HD also included a "ç" on its name... I just removed it and everything works fine now! Thanks a lot for the tip!

Reply

Answer 8

Aug 10, 2014 8:10 AM in response to Holger_S

Thanks Holger_S, your suggestion fixed the problem! My hard drive had the accented é and the æ in the name, so I renamed it without accent marks as you said and it works perfectly now.

Reply

Answer 9

mg234

Level 1

0 points

Mar 25, 2015 3:01 PM in response to olenoedotcom

I wasn't able to open .XLSM files. My hard disk name had space. I removed the space and restarted excel 2011. It can open macro files now. Thanks very much for the suggestion.

Reply

Answer 10

Nov 19, 2016 4:41 PM in response to admiralkymia

Delete this file:

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

Reply

Answer 11

Feb 13, 2017 3:36 AM in response to Roy Levitt

Removing this file solved it. Thanks

Reply