Call a macro in other workbook

[Davwe]

Ho can I call a macro in an other Excel workbook that is in an other
dir.

 

[Chip Pearson]

You have to open the workbook first in order to execute the
macro. Then use Application.Run to execute that actual macro.
E.g.,

Application.Run "Book2.xls!TheMacro"


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Davwe]

Thanks, it works )))