Calling an Add-In

[Guest]

I want to run an add-in (specifically, Rob Bovey's Code Documentor) from a
VBA module. I have tried Application.Run "VBACodeDocumentor.xla", but the
error message says it can't find the macro. It is listed in the project
window.

What changes do I need to make?

 

[Jim Rech]

You could just execute its menu item:

CommandBars("Tools").Controls("Document Project").Execute

--
Jim
|I want to run an add-in (specifically, Rob Bovey's Code Documentor) from a
| VBA module. I have tried Application.Run "VBACodeDocumentor.xla", but the
| error message says it can't find the macro. It is listed in the project
| window.
|
| What changes do I need to make?
|
| --
| Bill @ UAMS

 

[Guest]

Works great. Thanks!

 

[Laurel]

'Document Project' appears 5 times in Excel Tools menu!

But doesn't work. Does anyone have any idea how to remove these entries?? I even uninstalled Excel,
restarted my computer, and reinstalled it. The menu item lines are still there, and are useless.

I see no items in add/remove programs that would correspond to this add-in , either.

Thanks to all,
Laurel

 

[Laurel]

Removing Project Document from Tools menu

I solved the problem from the response to the other person's problem in this thread.

In the Immediate Window, I entered: CommandBars("Tools").Controls("Document Project").Delete
and repeated it until there were no more menu entries!

-Laurel