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 :
-
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 ?
-
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.)