One can open a group of workbooks in a single step by creating a workspace file.
A workspace file saves information about all open workbooks, such as their locations, window sizes, and screen positions. When you open a workspace file by using the Open
command (File menu), Microsoft Excel opens each workbook saved in the workspace.
The workspace file does not contain the workbooks themselves, and you must continue to
save changes you make to the individual workbooks.
1. Open the workbooks you want to open as a group.
2. Size and position the workbook windows as you want them to appear
the next
time you use the workbooks.
3. On the View tab, click Save Workspace.
4. In the File name box, enter a name for the workspace file.
The workspace file has an extension (*.xlw)
This feature is really helpful while working with multiple Workbooks located in different folders. You can open the multiple files by just opening one file.....
Isn't this sounds good ? If yes, try now.......
