MrExcel.com - Your One Stop for Excel Tips & Solutions

Opening two workbooks at the same time

Posted by Mike on February 20, 2001 8:49 AM

I have created two workbooks (WB). One is called estimate with three worksheets and the other WB is called database. I made the estimate WB a template. My question is when I open a new estimate WB I would like the database workbook to open up too. I cant find out how to do this. I have the excel 2000 bible book if there is a referance in it one could point me to.

Thanks for the help

Mike

Posted by Celia on February 20, 2001 4:13 PM

Mike
Put the following in the ThisWorkbook code module of the Estimate WB :-

Private Sub Workbook_Open()
Workbooks.Open Filename:="C:\database.xls"
End Sub

Change the file path as necessary.
Celia