Menu Item

[Greg B]

Hi all,

I am wondering how to get the toolbar item get From &Scanner or Camera. to
show using vba.

I mean the insert - picture - From & Scanner or Camera

Thanks

Greg

 

[JP]

Check out http://tinyurl.com/35jbhg

You can make a list of all the commandbr controls.


HTH,
JP

 

[Greg B]

Thanks for that, just how do I use it?

Thanks
Greg
Check out http://tinyurl.com/35jbhg

You can make a list of all the commandbr controls.


HTH,
JP

 

[JP]

Download CommandBar Tools from the link on that page. Unzip the file
and extract the XLA file to your destination of choice. Double click
on the file and make sure you enable macros if prompted. It adds a
menu to the toolbar on top called "EDC Tools" you would click on that
and select "List all commandbar controls". Then you can simply search
for the control you are trying to automate.

HTH,
JP

 

[Greg B]

Thanks for that, I never noticed the extra menu item.

Greg
Download CommandBar Tools from the link on that page. Unzip the file
and extract the XLA file to your destination of choice. Double click
on the file and make sure you enable macros if prompted. It adds a
menu to the toolbar on top called "EDC Tools" you would click on that
and select "List all commandbar controls". Then you can simply search
for the control you are trying to automate.

HTH,
JP

 

[JP]

You're welcome, post back the final code so others can learn as well.


Thx,
JP