Thread: save all files
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vezerid vezerid is offline
external usenet poster
 
Posts: 751
Default 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