#1   Report Post  
BillCPA
 
Posts: n/a
Default 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
  #2   Report Post  
Jim Rech
 
Posts: n/a
Default

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


  #3   Report Post  
BillCPA
 
Posts: n/a
Default

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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calling another workbook not working malik641 Excel Worksheet Functions 2 June 24th 05 07:36 PM
When calling a different file, can I make the tab equal to a cell? thebigd08 Excel Discussion (Misc queries) 1 June 24th 05 12:39 AM
Macro (Print) - Calling Named Ranges KGlennC Excel Discussion (Misc queries) 1 March 19th 05 09:20 PM
Macro calling another Macro spartanmba Excel Discussion (Misc queries) 2 February 9th 05 10:20 PM
Calling MVP's & pro's urgently please !! Adam Excel Discussion (Misc queries) 6 January 3rd 05 10:45 AM


All times are GMT +1. The time now is 04:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"