Addin Macro Call

R

Rick

What is the correct format of the call statement for a addin workbook that
contains a macro in module1 with ThisWorkbook properties set to addin = true.
 
B

Bill Renaud

<<What is the correct format of the call statement for a addin workbook
that contains a macro in module1...>>

Something like:
YourProject.YourModule.YourSub

or

[MyProject.xls].[MyModule].Main

See the topics "Avoiding Naming Conflicts" and "Calling Procedures with the
Same Name" in Visual Basic Conceptual Topics.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change a great number of words in word files, with a macro as short as possible. 5
Setting column width in a table with a macro is not working 0
can we copy the code from the addin to excel workbook 2
How to map a shortcut key to a routine in COM AddIn for Excel 2007 21
vba excel 2007 data mining 0
VBA Saveas Addin creates a ppa file instead of ppam 0
Word macro that can call cells out of Excel for a find and replace 0
Trying to read CustomDocumentProperties of an open 2007 AddIn 1

Top