View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
cr113 cr113 is offline
external usenet poster
 
Posts: 11
Default Calling excel macro not located in that workbook.


Can I call an excel macro programmatically from another workbook in
Excel 2003?

For example suppose I have 2 workbooks, book1.xls and book2.xls:


book1.xls
module1
macro1

book2.xls
module2
macro2

How would I call book2.module2.macro2 from book1.module1.macro1?