MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Opening a workbook from within another workbook


Posted by Steve on August 07, 2001 12:26 AM

I have a small business that entails me servicing equipment for different clients on a given day each week.
I have a sheet for each day of the week with the appropriate names and addresses of the clients in one workbook named "CLIENT". I wish to have a seperate workbook named "EQUIPMENT" containing information on the equipment that each client posseses.
I would like to be able to open the "EQUIPMENT" workbook from the "CLIENT" workbook to access the information.
Is this possible.
Any help would be appreciated--


Posted by Chuck on August 08, 2001 5:32 AM

Create a macro with the command Workbooks.Open FileName:="C:\Directory Name\Filename.xls". Put a button on your form and assign this macro to it. You can also create the macro using Tools / Macro / Record New Macro.