Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel toolbars
Message
From
27/07/2007 17:40:32
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
27/07/2007 17:32:51
Gary Foster
Pointsource Consulting LLC
Chanhassen, Minnesota, United States
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Miscellaneous
Thread ID:
01244277
Message ID:
01244278
Views:
19
>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
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform