How do I run a Sub Procedure that's in another open Workbook?

[charley3]

I have two workbooks open at the same time, one is the ActiveWorkbook, the other is an inactive workbook.

The ActiveWorkbook's name is always "BatchImport" with filename of "BatchImport.xls".

The inactive workbook's name is always "New Med Sheets1" with filename of "New Med Sheets1.xls".


Both workbooks have Option Private Module at the top of the module they're in.

In the ActiveWorkbook, I have a Sub Procedure that needs to run/call/trigger a Sub Procedure in the inactiveworkbook.

I've never done that before, and I can't find it in my books or VBE help or Object Browser. So some online expert advice would be greatly appreciated.

Thank you

[quekbc]

This link here might help you with what you are looking for (i.e. use Application.Run)

http://www.rondebruin.nl/win/s9/win001.htm

[charley3]

Thanks quekbc! Your info/link worked great.

My code is now:

Application.Run "'New Med Sheets1'!Import_Data_ALL_sheets"

It now works well and does exactly what I need. It runs the Import_Data_ALL_sheets Sub Procedure in the other workbook.

[quekbc]

That's good to hear charley3. Can you also mark this thread as SOLVED?

Click Thread Tools above your first post, select "Mark your thread as Solved". Or click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes.