I have some code that initially opens another workbook, ie:

Set wb = Workbooks.Open ("myotherfile.xlsx")

This code opens the other workbook file and the "handle"
gets stored in the "wb" variable.

My question is, now that the workbook is open, how can
I run any of the subroutines in this other workbook???

(Assume that the "myotherfile.xlsx" file has a subroutine
named "Public Sub Foo (ByVal x as Integer)"... I would
like to call this function!)

Some have suggested that I need to use the Application.Run
method for this. Is that right?? How do I use that?

thank you