R – Legacy VBA Solutions are not working in Office 2007

add-inms-officepowerpointvba

Folks,

An existing system that was based on VBA was installed on a machine that has Office 2007 and it didn't work, the issues I faced are :

  1. A PowerPoint Add-in (.PPA) is no longer able to create the custom buttons in the shortcut menu, did Office 2007 change the commandbar names ?

  2. The MSI (written in Wix) didn't install the files in XLStart folder as it was doing so in Office 2003, did Office 2007 use a new name for XLStart or another mechanism ?

Any advice on how to troubleshoot the issues above is highly appreciated

Best Answer

For issue one, I think you are going to be stuck modifying the add-in to cooperate with the ribbon.

For issue two, I suspect that the start up location was hard coded. If that is the case, try writing to Excel.Application.StartupPath (You will need to set a reference to Excel if you are doing this from PowerPoint.)