Some notes on this from Chip Pearson
Application.Run "Book1.xls!MacroName"
Or, if the book name contains spaces, (watch the quotes)
Application.Run "'Book One.xls'!MacroName"
--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl
"James" wrote in message ...
I have a subroutine which opens a workbook. I want the
subroutine in the first workbbok to then go on and run a
subroutine in the second workbook that I've just opened.
How do I go about doing this?
Hope this is clear.
James