Same custom toolbar in all Office apps

[MAB]

I want to make a custom toolbar (including custom code for the buttons) that
is permanently loaded in all Office applications. I have VB6 and VBA
development tools. Do I need to create an Add-in to do this?

The button macros/app will have to somehow know which Office application
it's running in, in order to utilize the correct object model. In other
words, I want to make my portions of my code generic enough to work
regardless of the Office application it's running in.

 

[Cindy M.]

Hi =?Utf-8?B?TUFC?=,

I want to make a custom toolbar (including custom code for the buttons) that
is permanently loaded in all Office applications. I have VB6 and VBA
development tools. Do I need to create an Add-in to do this?

The button macros/app will have to somehow know which Office application
it's running in, in order to utilize the correct object model. In other
words, I want to make my portions of my code generic enough to work
regardless of the Office application it's running in.

You should be able to do this using VB6 to create a COM Addin dll. I don't
recommend using the VBA developer tools as those were discontinued in Office
2003. Search MSDN for documentation on creating Office Addins.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail

 

[MAB]

Thank you Cindy.

Hi =?Utf-8?B?TUFC?=,

You should be able to do this using VB6 to create a COM Addin dll. I don't
recommend using the VBA developer tools as those were discontinued in Office
2003. Search MSDN for documentation on creating Office Addins.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)


This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail