Application.Run "otherbook.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