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"
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Call routines of other workbooks? 1
Calling Subroutines from sub-routine 4
Run subroutines in other workbooks? 4
Calling subroutine defined in another workbook (autostart workbook) 5
Call Subroutine in Excel 3
open workbook in new window using VBA 2
Call subroutine from another workbook 2
Help with Calling a subroutine in the ThisWorkbook Class 6

Back
Top