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