Excel VBA Immediate Window Question

[cr731]

When using the Immediate Window in the VBA editor, if running a macro from one of the open workbooks, is it possible to specify which workbook it runs from instead of having to click into the project containing the macro?

For example, say I have three open workbooks and each of them contains a macro in Module1 called "Test." I would run this in the Immediate Window by typing

Module1.Test

This runs the Test macro from whichever project I have selected in the Project Explorer pane. I'd like to know if it's possible to specify which project to run from instead so I don't have to keep clicking into the project containing the macro, something like

Workbook1.Module1.Test

Is this possible? This is a simplified example but it becomes cumbersome in more complex scenarios.

Thanks

 

[John_w]

By using Application.Run and specifying the workbook Name:

Application.Run "'" & Workbooks(1).Name & "'!NameOfMacro"

where 1 is the index number of the open workbook.

If NameOfMacro occurs in more than 1 module in the workbook then specify the module name:

Application.Run "'" & Workbooks(1).Name & "'!Module1.NameOfMacro"