save all files
On Mar 7, 1:21 pm, "Carpe Diem" wrote:
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
|