Run subroutines in other workbooks?

[Robert Crandal]

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

 

[Robert Crandal]

But the subroutine is located in a different workbook (that is also
open).....
How do I specify the other workbook??

I thought it would be something like:

Workbooks("otherbook.xlsm").Run Foo, 1

But that doesn't seem to work....

 

[Bob Phillips]

Application.Run "otherbook.xlsm"!Foo",1

HTH

Bob

But the subroutine is located in a different workbook (that is also
open).....
How do I specify the other workbook??

I thought it would be something like:

Workbooks("otherbook.xlsm").Run Foo, 1

But that doesn't seem to work....

hello
try run [sub name] or call [sub name] withouth the []

cheers

 

[Bob Phillips]

Sorry type there, should have been

Application.Run "otherworkbook.xlsm!Foo",1

HTH

Bob

But the subroutine is located in a different workbook (that is also
open).....
How do I specify the other workbook??

I thought it would be something like:

Workbooks("otherbook.xlsm").Run Foo, 1

But that doesn't seem to work....

hello
try run [sub name] or call [sub name] withouth the []

cheers

 

[Paul]

Don't forget that, with files that contain such characters as spaces, you'll
need to add quotes :

Application.Run "'My Other Workbook.xlsm'!Foo",1

--
If the post is helpful, please consider donating something to an animal
charity on my behalf.

Sorry type there, should have been

Application.Run "otherworkbook.xlsm!Foo",1

HTH

Bob

But the subroutine is located in a different workbook (that is also
open).....
How do I specify the other workbook??

I thought it would be something like:

Workbooks("otherbook.xlsm").Run Foo, 1

But that doesn't seem to work....

hello
try run [sub name] or call [sub name] withouth the []

cheers

.