ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Calling an Add-In (https://www.excelbanter.com/excel-discussion-misc-queries/39919-calling-add.html)

BillCPA

Calling an Add-In
 
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

Jim Rech

You could just execute its menu item:

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

--
Jim
"BillCPA" <Bill @ UAMS wrote in message
...
|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



BillCPA

Works great. Thanks!
--
Bill @ UAMS


"Jim Rech" wrote:

You could just execute its menu item:

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

--
Jim
"BillCPA" <Bill @ UAMS wrote in message
...
|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





All times are GMT +1. The time now is 02:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com