ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Call routines of other workbooks? (https://www.excelbanter.com/excel-programming/438208-call-routines-other-workbooks.html)

Robert Crandal

Call routines of other workbooks?
 
Is it possible to open another macro enabled workbook and
call any subroutines that exist in modules of that workbook??
I know how to write code that opens another workbook, but
I'm not sure if I can call other subroutines of that workbook.

thank u





Ron de Bruin

Call routines of other workbooks?
 
See the help for Application Run



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Robert Crandal" wrote in message ...
Is it possible to open another macro enabled workbook and
call any subroutines that exist in modules of that workbook??
I know how to write code that opens another workbook, but
I'm not sure if I can call other subroutines of that workbook.

thank u






All times are GMT +1. The time now is 06:10 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com