Close workbook without being prompted to save in VBA
 

I am using the following code to close and save a workbook:

Application.DisplayAlerts = False
ActiveWorkbook.Close SaveChanges:=True

I can't seem to get this to work without prompting me to save, even though I
did application.displayalerts = false and I told it to save in the
active.workbook.close command.

Close workbook without being prompted to save in VBA
 

On Dec 19, 10:36 pm, J Wait wrote:
I am using the following code to close and save a workbook:

Application.DisplayAlerts = False
ActiveWorkbook.Close SaveChanges:=True

I can't seem to get this to work without prompting me to save, even though I
did application.displayalerts = false and I told it to save in the
active.workbook.close command.

I made it work with

ActiveWorkbook.Save
ActiveWorkbook.Close

/Tommy

Close workbook without being prompted to save in VBA
 

Do you have any "on close" event code. If so then it may be altering the
workbook which will prompt the save message. You can use Activeworkbook.Saved
= true to make the application believe that a save is not necessary...
--
HTH...

Jim Thomlinson


"J Wait" wrote:

I am using the following code to close and save a workbook:

Application.DisplayAlerts = False
ActiveWorkbook.Close SaveChanges:=True

I can't seem to get this to work without prompting me to save, even though I
did application.displayalerts = false and I told it to save in the
active.workbook.close command.

Close workbook without being prompted to save in VBA
 

I tried what you said to begin with, and even though I told it to save before
I told it to close, it still prompted me to save on the close command. I
don't know what else to try. I've never run into this problem before.

I have also tried "ActiveWorkbook.Close True", and it still prompts me to
save.

To answer Jim's question, I don't have any "on close" event code, so I can't
try what he suggested.

Please let me know if you have any other ideas I could try. I'm hung up on
this one piece of the code!

"TG" wrote:

On Dec 19, 10:36 pm, J Wait wrote:
I am using the following code to close and save a workbook:

Application.DisplayAlerts = False
ActiveWorkbook.Close SaveChanges:=True

I can't seem to get this to work without prompting me to save, even though I
did application.displayalerts = false and I told it to save in the
active.workbook.close command.

I made it work with

ActiveWorkbook.Save
ActiveWorkbook.Close

/Tommy

Close workbook without being prompted to save in VBA
 

On Dec 19, 10:59 pm, J Wait wrote:
I tried what you said to begin with, and even though I told it to save before
I told it to close, it still prompted me to save on the close command. I
don't know what else to try. I've never run into this problem before.

I have also tried "ActiveWorkbook.Close True", and it still prompts me to
save.

To answer Jim's question, I don't have any "on close" event code, so I can't
try what he suggested.

Please let me know if you have any other ideas I could try. I'm hung up on
this one piece of the code!

"TG" wrote:
On Dec 19, 10:36 pm, J Wait wrote:
I am using the following code to close and save a workbook:

Application.DisplayAlerts = False
ActiveWorkbook.Close SaveChanges:=True

I can't seem to get this to work without prompting me to save, even though I
did application.displayalerts = false and I told it to save in the
active.workbook.close command.

I made it work with

ActiveWorkbook.Save
ActiveWorkbook.Close

/Tommy

The reason could be a formula containing NOW() or TODAY() as these are
changing ' on the fly' and therefore the worksheet believe it has
changed, and must be saved on closing..

Maybe this will work, I haven't tried yet

ActiveWorkbook.Save
ActiveWorkbook.Saved
ActiveWorkbook.Close

/Tommy

Close workbook without being prompted to save in VBA
 

Thank you so much Tommy and Jim! Here's what ended up working:

ActiveWorkbook.Save
ActiveWorkbook.Saved = True
ActiveWorkbook.Close

You solved a huge headache for me! Thanks!

"TG" wrote:

On Dec 19, 10:59 pm, J Wait wrote:
I tried what you said to begin with, and even though I told it to save before
I told it to close, it still prompted me to save on the close command. I
don't know what else to try. I've never run into this problem before.

I have also tried "ActiveWorkbook.Close True", and it still prompts me to
save.

To answer Jim's question, I don't have any "on close" event code, so I can't
try what he suggested.

Please let me know if you have any other ideas I could try. I'm hung up on
this one piece of the code!

"TG" wrote:
On Dec 19, 10:36 pm, J Wait wrote:
I am using the following code to close and save a workbook:

Application.DisplayAlerts = False
ActiveWorkbook.Close SaveChanges:=True

I can't seem to get this to work without prompting me to save, even though I
did application.displayalerts = false and I told it to save in the
active.workbook.close command.

I made it work with

ActiveWorkbook.Save
ActiveWorkbook.Close

/Tommy

The reason could be a formula containing NOW() or TODAY() as these are
changing ' on the fly' and therefore the worksheet believe it has
changed, and must be saved on closing..

Maybe this will work, I haven't tried yet

ActiveWorkbook.Save
ActiveWorkbook.Saved
ActiveWorkbook.Close

/Tommy