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

COM addin won't connect when workbook opened via another workbookfrom another instance 3
can we copy the code from the addin to excel workbook 1
How to enable to excel options from addin using VBA/Macro coding 0
Call an addin Macro from Workbook_Open event 2
How to map a shortcut key to a routine in COM AddIn for Excel 2007 21
Excel VBA 2
Add-in Question (common code) 2
Copy a Sheet to an AddIn 2

Top