| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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/ |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Call a macro in other workbook
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can run a macro ( call a macro) on selection of any filtercriteria? | Excel Worksheet Functions | |||
| Call an Access macro from an Excel macro | Excel Discussion (Misc queries) | |||
| How do I call number values form one workbook to another workbook | Excel Worksheet Functions | |||
| macro call | Excel Discussion (Misc queries) | |||
| How to call a function from another workbook | Excel Discussion (Misc queries) | |||
![Davwe[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
