ExcelBanter - Run macro in another Excel workbook

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Run macro in another Excel workbook (https://www.excelbanter.com/excel-discussion-misc-queries/158325-run-macro-another-excel-workbook.html)

pokdbz

Run macro in another Excel workbook

Is there a way in VB to run a macro or function from another Excel workbook?

If so how can I do this?

Jim Thomlinson

Run macro in another Excel workbook

application.run "myBook.xls!myMacro"

http://msdn2.microsoft.com/en-us/lib...ffice.10).aspx
--
HTH...

Jim Thomlinson

"pokdbz" wrote:

Is there a way in VB to run a macro or function from another Excel workbook?

If so how can I do this?

All times are GMT +1. The time now is 12:13 PM.