PC Review


Reply
Thread Tools Rate Thread

Addin Macro Call

 
 
Rick
Guest
Posts: n/a
 
      20th Dec 2007
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.
 
Reply With Quote
 
 
 
 
Bill Renaud
Guest
Posts: n/a
 
      20th Dec 2007
<<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.
--
Regards,
Bill Renaud



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Call AddIn-Functions from VBA-Macro Steffen Grellmann Microsoft Outlook Program Addins 7 23rd Jul 2008 09:34 PM
System.Addin , Call Host From Addin bivoauc Microsoft Dot NET Framework 2 5th Dec 2007 04:37 AM
Call an addin Macro from Workbook_Open event r.c.j.tongeren@arcadis.nl Microsoft Excel Programming 2 29th Aug 2007 07:19 PM
Pls clarify how to call an Addin from another addin using VBA =?Utf-8?B?UHJhYmFrYXI=?= Microsoft Excel Programming 1 11th Jan 2006 09:08 AM
COM addin call missing ken Microsoft Excel Programming 0 22nd Jul 2003 03:39 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:09 AM.