View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default 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