Call a macro in other workbook
 

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


---
Message posted from http://www.ExcelForum.com/

Call a macro in other workbook
 

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" wrote in message
...
Ho can I call a macro in an other Excel workbook that is in an
other
dir.


---
Message posted from http://www.ExcelForum.com/

Call a macro in other workbook
 

Thanks, it works :-))))


---
Message posted from http://www.ExcelForum.com/