Vba - Save but don't close

[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

 

[Bob Phillips]

ThisWorkbook.Save

--
HTH

Bob

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

 

[FSt1]

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

 

[Sandy]

Once again thank you Bob

Sandy

ThisWorkbook.Save

--
HTH

Bob

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