ExcelBanter - Calling a sub from a different workbook

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Calling a sub from a different workbook (https://www.excelbanter.com/excel-programming/373511-calling-sub-different-workbook.html)

jdcox1999

Calling a sub from a different workbook

How can I call a subroutine that is in another workbook, without using
a menu option?

Tom Ogilvy

Calling a sub from a different workbook

application.run "Myotherworkbook.xls!Mymacro"

assumes the other workbook is open.

--
Regards,
Tom Ogilvy

"jdcox1999" wrote:

How can I call a subroutine that is in another workbook, without using
a menu option?

All times are GMT +1. The time now is 11:51 PM.