Build In Control Connector

Add-in Express™ Support Service
That's what is more important than anything else

Build In Control Connector
 
Joseph Poon




Posts: 15
Joined: 2007-06-17
Quoted from the Development Guide is:

Add a BuiltinControlConnector onto ADXAddinModule. Set its Id property to the command bar control ID from your host application. To connect the component to the command bar control, leave its CommandBar property empty. To connect the component to the control on a given toolbar, specify the toolbar in the CommandBar property. To override the default action of the control, use the Action event. The component traces the context and when the context changes, it reconnects to the currently active instance of the command bar control with the given Id taking away this task from you.

1) Trying to modify the 'Open (ID =23)' control default action.
2) Followed the message above, setting the BuildinControlConnector 'ID' property to 23.
3) Leaving the 'CommandBar' property to NONE
4) Setting the 'DisableDefaultAction' property to True.
5) Compiled and registered the addin for Excel in VS2005.
6) The 'Open' control's action on the 'Standard' toolbar was modiified.
7) The 'Open' control's action on the 'Worksheet Menu Bar/File' was NOT modified.

Did I miss anything?

Posted 25 Jun, 2007 00:33:27 Top
Sergey Grischenko


Add-in Express team


Posts: 7233
Joined: 2004-07-05
Hi Joseph.

In this case you should set the CommandBar property of the first built-in connector to the 'Standard' command bar and in the second connector it should be a reference to the 'Worksheet Menu Bar' component.



P.S. We always do our best to answer your forum requests as soon as possible. However, we apply the rule "first in first out" with Premium Support Service subscribers taking priority. Please understand it may take us some time to do research on the issue. Please be assured we will let you know as soon as the best possible solution is found.
Posted 25 Jun, 2007 11:12:25 Top
Joseph Poon




Posts: 15
Joined: 2007-06-17
Sergey,

I could not change the CommandBar property. This property is a dropdown combo box for selection only.
Posted 25 Jun, 2007 11:42:25 Top
Sergey Grischenko


Add-in Express team


Posts: 7233
Joined: 2004-07-05
Right. Now you need to add two command bars named 'Standard' and 'Worksheet Menu Bar' and use them in the CommandBar property of built-in controls.
Posted 25 Jun, 2007 12:45:28 Top
Joseph Poon




Posts: 15
Joined: 2007-06-17
Thanks Sergey.

What does that ActionEx event do?
Posted 25 Jun, 2007 13:39:14 Top
Sergey Grischenko


Add-in Express team


Posts: 7233
Joined: 2004-07-05
The ActionEx event works in the same way as the Action event but it has the Cancel argument in addition.
Posted 26 Jun, 2007 13:21:50 Top