calling sub from another workbook

  • Thread starter Thread starter James
  • Start date Start date
J

James

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
 
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"
 
Back
Top