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.
|