Open two excel workbooks at the same time

  • Thread starter Thread starter noah
  • Start date Start date
N

noah

Is there a way to have an excel workbook automaticaly open anothe
workbook when it is opened?
Say I have:
"workbook1"
and it opens with:
"workbook2"
but I can still open
"workbook2" all by itself
 
Noah;

Put in the following macro into workbook 1 and change the
code to be your second workbook.

Sub Auto_Open()
Workbooks.Open("C:\TheSecondWorkBook.xls")

End Sub

Thanks,

Greg
 
Everyone I know told me it counld'nt be done.
I have since learned that anything is practically possible on Excel.
 
Back
Top