How do I install Visual Basic for Applications 2013 in Office 365?

I've recently taken out a subscription to Office 365 and have downloaded the desktop office programs. However, I'm trying to install an EPM excel addin and it's complaining that it needs "Microsoft Visual Basic for Application 2013 or later".

The thing is, all instructions online for Office 2013 involve going to Add/Remove programs and clicking change, which brings up the repair Office 365 dialog instead of allowing me to install the optional VBA component.

Does anyone have an idea as to how I can install VBA 2013 when I've got Office 365?

Solution 1:

I'm not sure if this is the same thing you guys have been looking for, but I found I was able to access VBA in Office365 by opening Excel, going to FILE > OPTIONS, select 'Customize Ribbon', add 'Developer' to show in the ribbon. Now simply go to the Developer tab and click 'Visual Basic', which will pop open a new window.

Solution 2:

I also got hit with this issue where I needed VBA 2013, but couldn't install it via the 365 installer.

My solution was to borrow a friends' Office 2013 install disc and only install the optional VBA component.

You don't need to enter a key to install this component!