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.


"Bob Phillips" wrote:

Sorry type there, should have been

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

HTH

Bob


"Robert Crandal" wrote in message
...
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....



"D_Rennie" wrote in message
...

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

cheers




.