How to run macro from another file

  • Thread starter Thread starter Piotr
  • Start date Start date
P

Piotr

Hi,
is it possible to have vba code in workbook ehich would do:

Workbooks.Open Filename:="D:\somefile.xls"
'and then
run Sub one - this I have no clue how to make ?
run Sub two
run Sub three
and
ActiveWorkbook.Close
 
Application.Run "'somefile.xls'!SubOne"
Hi,
is it possible to have vba code in workbook ehich would do:

Workbooks.Open Filename:="D:\somefile.xls"
'and then
run Sub one - this I have no clue how to make ?
run Sub two
run Sub three
and
ActiveWorkbook.Close
Click to expand...
 
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

Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
help with VBA program to import and add formatted files to one file 0
Save Macro enabled WB as w/o macro 13
Macro Question 2
Workbooks.Open always have 1
error when running macro from another workbook 8
Macro loop opening files in folder successivly 5
Get names of closed workbooks? 5

Back
Top