Vba - Save but don't close

  • Thread starter Thread starter Sandy
  • Start date Start date
S

Sandy

I know that :-

ThisWorkbook.Close SaveChanges:=True

will Close the workbook and Save. If I just wanted to Save the workbook in a
macro without closing would it be :-?

ThisWorkbook.SaveChanges:=True

Sandy
 
ThisWorkbook.Save

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
hi,
Activeworkbook.save

if you have more that one wb open and want to save them all....
dim wb as workbook
for each wb in application.workbooks
wb.save
next wb

regards
FSt1
 
Back
Top