Getting my add-ins to run in Excel 2007 1

[RobBroekhuis]

Well, my company decided to upgrade to Office 2007. Which means that all of my VBA add-ins, which defined custom menus and added items to standard menus, are just about completely non-functional. Can anyone point me to a good online resource to help me sort out a solution? A quick web search didn't turn up much of value...
Thanks!

Rob

 

[fumei]

Can anyone point me to a good online resource to help me sort out a solution?"

What do you mean by "solution"? Some sort of easy automated thingie that will parse, check, and fix your existing code to work for 2007?

This is not going to happen.

For one thing, if any of your code uses Application.FileSearch you will have to remove any, and all, references to that. FileSearch is totally removed from 2007 and is no longer in the Object Model. It is gone, gone, gone.

I do not think there is a magic bullet anywhere. You are likely going to have to carefully test (and possibly change) all your code in 2007.

faq219-2884

Gerry
My paintings and sculpture

 

[RobBroekhuis]

Nope, not looking for something that will do everything for me. A site/page addressing VBA issues arising from the transition to Office2007, with some best practices, would be helpful .

Rob

 

[strongm]

>some best practices,

The best practice is not to upgrade if you have apps that rely on custom menus/command bars ...

As you have discovered, any code that uses commandbars is completely stuffed thanks to Microsoft's decision to move to a new interface metaphor - the ribbon

Here's an extract from a book that shows how you can get VBA to work with the ribbon and how to customize it (

http://www.oaltd.co.uk/Spreads/Excel2007VBAProgRef_ch14.pdf).

Note in the very first paragraph it states "a way for it to be customized by developers and (to a certain extent) end users" which helps show you that in Office 2007 one of the Office 2007's team was to take customisation and coding away from end users, and give it to developers instead.

 

[RobBroekhuis]

Thanks strongm. That will be helpful for sure. I already feared that customization was partly taken away from me. I'll try to salvage what I can...


Rob