Well, the simple way is to open the codeless workbook's VBA module and click
on "Tools/References" at the top. Then select the name of the book with the
code and check it's box. At that point everything in the second book is
available to the first. However it will also automatically open the second
book whenever you open the first if that's a problem.

Once you've checked the box as above, then you just use the subroutine name
in the first book same as if the routine lived in the first book.

Bill
-------------------------
"Coby" wrote in message
...
If I had one workbook open, but the vba modules were in another
workbook which is closed, does anyone know if there is a way for the
codeless workbook to run the subroutine which is in the other
workbook?

Any help is sincerely appreciated.

Coby.