Open two excel workbooks at the same time

[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

 

[GJones]

Noah;

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

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

End Sub

Thanks,

Greg

 

[noah]

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