MSOffice 2000 Shortcut Bar - Customize w/code

Hi,

I'm having a problem finding a way to customize the MSOffice Shortcut Bar or some might say toolbar, with VBS or VB.Net code. I believe the key would be to create an application object as in, i.e., CreateObject("Excel.Application"), however, CreateObject("MSOffice.Application") does not work. I've tried many other variations with no luck. A script would of course eliminate the tedious custom shortcut bar setup for every PC in a rollout. (Deleting and Adding various buttons and selecting the option, “Auto Fit into Title Bar area”) There doesn't seem to be anything on the internet on the customizing of the shortcut bar programmatically. Has anyone a solution or any ideas? Is this even possible? This has me completely stumped. :confused:

Thank you for any help!! :)

I don't think the Office shortcut bar app allows automation. However, I'm sure it stores its settings somewhere in the registry. So you should be able to read the registry values from a PC where you've set it up, and then apply those to all the others.

I don't think the Office shortcut bar app allows automation. However, I'm sure it stores its settings somewhere in the registry. So you should be able to read the registry values from a PC where you've set it up, and then apply those to all the others.

Thank you! :)

I have thought of the registry as an option, albeit a last resort. (Like brain surgery, :whoops: I would want to make sure that what I was changing would have no ill effect). I’ve done a search of the registry, and in each of the five instances where “Shortcut Bar” is found; I have found no correlation of the settings to an MSOffice Shortcut Bar setting. It may be buried so deep in the registry, (under a totally different keyword) that I may never find it. :( Someone told me that I might be better off looking for an API for the shortcut bar. Would this be a better idea? :rolleyes:

Saying that you will "use the API for X" is pretty much the same thing as saying "automate X"... so you're back at the same question - can it be automated? Try adding a reference to msoffice.exe. If that works, then check in the Object Browser what objects, properties, methods etc it exposes. If you cannot add a reference to it, then it can't be automated.