>Hi,
>This is only slightly related to VFP in that I'm building some spreadsheets with COM, but my real problem is Excel. We have some add-ins that have toolbars. How/where in the world do I control the docking of these toolbars? At startup, some are free floating and that annoys my users because they have to reposition them every time. Can this be controlled?
>
>I've found the excel10.xlb file that I *think* is supposed to have something to do with the toolbars but I have no idea what to do with it.
>
>I know this isn't a VFP issue, but there is an awful lot Office knowledge here!
>
>Thanks.
>
>Gary
Do you have the source of add-ins? If so using the SDK you can modify them to dock their toolbars temselves. Well I know it was just a try - or they could set the recorded macro as a startup macro:)
You can automate them from within VFP, but you need their names. You can record a macro and dock them manually to get necessary code. In general toolbar code looks like:
oExcel.CommandBars(barname/uniqueindex)...
I don't remember full syntax off the top of my head but it'd be something like that.
Cetin