CommandBarControl need an explanation

Question

4.00/5 (1 vote)

See more:

Hi everyone,
Could someone help me with this code?

VB

Dim cmdBar As Microsoft.Office.Core.CommandBarControl
Dim cmdBarButton As Microsoft.Office.Core.CommandBarButton

VB

cmdBar = Globals.ThisAddIn.Application.CommandBars("Cell") _
.Controls.Add(Office.MsoControlType.msoControlPopup, , , 1, )

VB

cmdBarButton = TryCast(cmdBar.Controls.add _(Office.MsoControlType.msoControlButton, , , 1, ), Microsoft.Office.Core.CommandBarButton)

This code is working, but however, I don't understand how and why, because there is no Method Controls for cmdBar Object?

cmdBar.Controls
Why is it working and how to make it better?
Thanks in advance.

(This code is not written by myself.)

Posted 14-Apr-11 22:13pm

Dragan01

Updated 14-Apr-11 22:27pm

Sandeep Mewara

v2

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Jeffrey Enzo · Answer 1 · 2011-04-14T22:24:00

Solution 1

If you're using Visual Studio, use Breakpoint in your code to find out what it's doing on each phase of your code.

Check MSDN: http://msdn.microsoft.com/en-us/library/ktf38f66(v=VS.90).aspx[^]

Posted 14-Apr-11 22:24pm

Jeffrey Enzo

Comments

Dragan01 15-Apr-11 4:29am

hi,
cmdBar is created as expected, but my questions is
how can cmdBarButton be created when there no Method Controls for cmdBar available is?

Manfred Rudolf Bihy · Answer 2 · 2011-04-14T22:40:00

Solution 2

The solution is found on this site here: http://msdn.microsoft.com/en-us/library/microsoft.office.core.commandbar_members(v=office.11).aspx[^].

Controls is not a method but rather a property of CommandBar.

Hope that clears it up for you!

Cheers,

-MRB

Posted 14-Apr-11 22:40pm

Manfred Rudolf Bihy

Comments

Dragan01 15-Apr-11 4:55am

Hello Manfred

That's correct: Controls is a Property, not Method
But exactly there is a Problem:
cmdBar is declared as CommandBarControl, not as CommandBar, why is the code working? Actually, the code should not be working because in CommandBarControl is no Property Control

I can change declaration of cmdBar from CommandBarControl to CommandBar and than I can be sure that the code is sure

Dragan01 · Answer 3 · 2011-04-14T23:11:00

Solved:

VB

Dim cmdBar As Microsoft.Office.Core.CommandBarPopup
Dim cmdBarButton As Microsoft.Office.Core.CommandBarButton

VB

cmdBar = TryCast(Globals.ThisAddIn.Application.CommandBars("Cell").Controls.Add(Office.MsoControlType.msoControlPopup, , , , True), Office.CommandBarPopup)

VB

cmdBarButton = TryCast(cmdBar.Controls.add(Office.MsoControlType.msoControlButton, , , 1, ), Microsoft.Office.Core.CommandBarButton)