PDA

View Full Version : Solved: Excel 2007 Add-ins



GMan
03-31-2009, 10:33 AM
I have created an Add-In that a co-worker in another office has been using. He recetnly asked me to make some updates which I completed and sent back over to him. I then found out he hasn't been using the add-in for a while because of the issue. Since then he has upgraded from Excel 2003 to Excel 2007. The Add-in I created was created in 2003 (which is what is on my PC). Is there some special process that needs to be completed to use the Excel 2003 Addin in Excel 2007?

Jan Karel Pieterse
04-01-2009, 12:42 AM
Not necessarily. 99% of your code should work just as well in 2007. Main differences are where menu and toolbar customisations end up: on the addins tab (This does not apply to most righclick menus, modifications to those mostly show where they should).

GMan
04-01-2009, 12:56 PM
It is good to know that my code will work (it does not do anything special). However, I do I get Excel 2007 to recognize the Add-In? In Excel 2003, I go to TOOLS -> ADD-INS... and can click on Browse... to locate the new Addin File. But this path does not seem to be present in Excel 2007.

Cosmo
04-01-2009, 01:21 PM
If you go to the "Excel Options" in the "Office" menu (if that's what it's called) at the top left, you select "Add-Ins" and you select the "Excel Add-Ins" in the drop down menu at the bottom, and click GO

Jan Karel Pieterse
04-01-2009, 10:10 PM
Or you use the old Excel 2003 menu shortcut keys: Alt+t, i.