MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Opening multiple workbooks

Posted by Duane Kennerson on December 10, 2000 4:30 PM

I want to write code that will open other workbooks when I open a specific workbook.
I tried the Workbook.Open filename procedure in the workbook open but it didn't seem to work.
The workbooks I want to open are all in the same folder and I tried adding the pathe to the
workbook open but to no avail. What am I doing wrong. Is there a simple way to do this.
Please help. It will be appreciated.


Posted by Celia on December 10, 2000 5:03 PM

Use the macro recorder to get the code for what you want to do, then copy and paste the code into the Workbook_Open event procedure.

Posted by Duane Kennerson on December 11, 2000 6:12 PM

Re: Duh, why didn't I think of that. Thanks Celia