Save Workspace...

Home Search Site Map

Up
Close
Exit
File Search...
Most Frequently Used
New...
Open...
Page Setup...
Permission
Print...
Print Area
Print Preview
Properties
Save
Save As...
Save as Web Page...
Save Workspace...
Send To
Web Page Preview

New! Excel User Group Now Open @ www.excelusergroup.org, Check It Out!


Menu command Type What happens next?
Save Workspace... ...

This option allows you to have, for example, multiple files open at once, maybe with the windows tiled, etc. and save the 'workspace' exactly as that.  By taking this option, if you regularly work across two or three files, you will be able to open this one workspace file and all the documents 'contained' in it will be opened. The individual 'workbooks' inside a 'workspace', can still be opened individually in the normal manner. It presents a 'Save Workspace' dialog with Workspaces selected in the 'Save as type:' drop-down.

VBA Sub SaveWorkspace()
Dim wb1 As Workbook
Dim wb2 As Workbook
Set wb1 = Workbooks.Add
Set wb2 = Workbooks.Add
'Add two workbooks and save them
wb1.SaveAs Filename:="C:\Test1.xls"
wb2.SaveAs Filename:="C:\Test2.xls"
'Save the workspace file. Note the use of Application and the file extension .xlw (workspace)
Application.SaveWorkspace Filename:="C:\Test.xlw"
End Sub

Top

Copyright Nick Hodge 2008. All Rights Reserved.