View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default calling sub from another workbook

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