Saving multiple Workbooks

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am new to 07.

I have had success saving multiple workbooks if each has had a change made.
I have trouble if I open multiple books and make a change to book 1 that book
2 links to. The link from book 2 updates but is not saved.

Is there a save all function as opposed to a close all? That will adress
this issue?
 
Maybe the example from VB Help can help:
This example saves all open workbooks and then closes Microsoft Excel.

For Each w In Application.Workbooks
w.Save
Next w
Application.Quit
Cheers,Joerg
 
Hi,

Save workbooks in an arranged workspace


When you open a workspace file (workspace file: A file that saves display
information about open workbooks, so that you can later resume work with the
same window sizes, print areas, screen magnification, and display settings. A
workspace file doesn't contain the workbooks themselves.), Microsoft Excel
opens each workbook saved in the workspace.

1. Open the workbooks you want to save in a workspace.
2. Size and arrange the workbook windows as you want them to appear when you
open the workspace.
3. On the File menu, click Save Workspace.
4. In the File name box, type a name for the workspace file.

Tip

To open the workbooks each time you start Excel, save the workspace file in
an alternate startup folder (alternate startup folder: A folder in addition
to the XLStart folder that contains workbooks or other files that you want to
be opened automatically when you start Excel and templates that you want to
be available when you create new workbooks.). Save only the workspace file,
not the workbook files, in the alternate startup folder.

Challa Prabhu
 
Back
Top