View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tim Zych[_4_] Tim Zych[_4_] is offline
external usenet poster
 
Posts: 58
Default Calling an XLA macro from code

Just to add...

Application.Run "Addin.xla!Mcr"

or if there are spaces in the book name:

Application.Run "'Addin 2.xla'!Mcr"

or if apostrophes/spaces:

Application.Run "'" & Replace("Addin's.xla", "'", "''") & "'!Mcr"


"Chrissy" wrote in message
...
How do I call an XLA macro from the code in another workbook?

Chrissy.