adding gap(separator) to an office(excel) command bar (tool bar) from add in using COM

[Mousam]

Hi All,
I am developing an excel add in using COM (in C++) . I can
successfully add button, combo box etc. to an office (excel) command
bar (tool bar) from my add in but I am not able to add a gap
(separator) to an office (excel) command bar (tool bar) from my add
in.

Can any one please tell me how to add gap (separator) to an office
(excel) command bar (tool bar) from excel (office) add in using COM?
Any pointer of example source code would be of great help.

Thanks & Regards,
Mousam Dubey

 

[Mousam]

Hi All,
I am developing an excel add in using COM (in C++) . I can
successfully add button, combo box etc. to an office (excel) command
bar (tool bar) from my add in but I am not able to add a gap
(separator) to an office (excel) command bar (tool bar) from my add
in.

Can any one please tell me how to add gap (separator) to an office
(excel) command bar (tool bar) from excel (office) add in using COM?
Any pointer of example source code would be of great help.

Thanks & Regards,
Mousam Dubey

Hi All,
Sorry for the inconvenience caused, but read

Any pointer of example source code would be of great help.

as

Any pointer or example source code would be of great help.

Thanks & Regards,
Mousam Dubey

 

[Jason Lepack]

The gap seperator is a property of the button.

Hi All,
Sorry for the inconvenience caused, but read

as

Any pointer or example source code would be of great help.

Thanks & Regards,
Mousam Dubey

 

[Mousam]

The gap seperator is a property of the button.

Hi Jason,
It would be great if you can please tell me the name of that
property of the button. I tried to find out about such a property but
I am not able to find it out that which property of button causes it
to behave like a gap (separator).

Note: I am creating add in for Excel 2002.

Thanks & Regards,
Mousam Dubey

 

[Jason Lepack]

You could have saved yourself alot of legwork by starting at object
explorer and not the internet.

A quick perusal of ObjectExplorer in VS2003 in the
Microsoft.Office.Core library shows CommadBarControl Interface has a
boolean property called "BeginGroup". It is inherited by
CommandBarButton, CommandBarCombo, etc.

Cheers,
Jason Lepack

 

[Mousam]

You could have saved yourself alot of legwork by starting at object
explorer and not the internet.

A quick perusal of ObjectExplorer in VS2003 in the
Microsoft.Office.Core library shows CommadBarControl Interface has a
boolean property called "BeginGroup". It is inherited by
CommandBarButton, CommandBarCombo, etc.

Cheers,
Jason Lepack

Thanks a lot Jason, It really helped.

 

[Jason Lepack]

You're welcome.

Thanks a lot Jason, It really helped.- Hide quoted text -

- Show quoted text -

 

[Dinesh Tripathi]

Hi ,
Can you please tell me how are you positioning the Excel Add-ins on toolbar.
Can you send me the code please .

Thanks
Dinesh Tripathi
9899985751

url:http://www.ureader.com/msg/10971282.aspx