save all files

[Carpe Diem]

Hi,

I usually use about 15 files at the same time and I would like to
arrange a way to save all files at once instead of save the files one
by one.

Anyone knows a add in or a macro that could do this ?

Thank you

Ricardo

 

[vezerid]

Hi,

I usually use about 15 files at the same time and I would like to
arrange a way to save all files at once instead of save the files one
by one.

Anyone knows a add in or a macro that could do this ?

Thank you

Ricardo

Ricardo,
the following code will save all files. It might need to be amended if
you seek more automation

Sub SaveAll
Dim w
For each w in Workbooks
w.save
Next w
End Sub

HTH
Kostis Vezerides

 

[Lori]

Try File > Save Workspace then click Yes to All at the save changes
prompt.

The workspace file that is saved will open all fifteen files at once
and you can arrange the files (window > arrange cascade, tiled,...)
before choosing this option to save the layout configuration.