calling sub from another workbook

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
 
R

Ron de Bruin

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"
 

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
Need Help with a VBA subroutine 0
Calling Subroutines from sub-routine 4
Run subroutines in other workbooks? 5
Calling subroutine defined in another workbook (autostart workbook) 5
open workbook in new window using VBA 2
Varialbe Loses Value 3
Call Subroutine in Excel 3

Top