Vba - Save but don't close
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" wrote:
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
|