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

Hi Sandy,

To save the workbook without closing it, you can use the following code:

1. Formula:

   ActiveWorkbook.Save 


This will save the workbook without closing it. If you want to save changes made to the workbook, you can use:

1. Formula:

   ActiveWorkbook.SaveChanges 


This will save any changes made to the workbook without closing it.

ThisWorkbook.Save

--
HTH

Bob

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

"Sandy" wrote in message
...
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

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

Once again thank you Bob

Sandy

"Bob Phillips" wrote in message
...
ThisWorkbook.Save

--
HTH

Bob

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

"Sandy" wrote in message
...
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