Prompt for saving a saved workbook
 

Suddenly when quitting my application and running the
save & close procedure Excel asks if I want to save the workbook at the
Application.quit command, spite it was already done?
Anyone knows what is causing this?
Dim WB as Workbook
For Each WB In Application.Workbooks
WB.Save
Next WB
Application.Quit

Prompt for saving a saved workbook
 

If you must quit the application rather than closing the workbooks,
try:

Dim WB as Workbook
For Each WB In Application.Workbooks
WB.Save
WB.Saved =True
Next WB
Application.Quit


--
The Code Cage Team

Regards,
The Code Cage Team
http://www.thecodecage.com
------------------------------------------------------------------------
The Code Cage Team's Profile: http://www.thecodecage.com/forumz/member.php?userid=2
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=30176

Prompt for saving a saved workbook
 

Is there perhaps something in your "Workbook_BeforeClose" procedure that is
making a change and therefore triggering the Save/Not Save question? Or
maybe a Worksheet event making a change?


--
Time is just the thing that keeps everything from happening all at once


"Mats Samuelsson" wrote:

Suddenly when quitting my application and running the
save & close procedure Excel asks if I want to save the workbook at the
Application.quit command, spite it was already done?
Anyone knows what is causing this?
Dim WB as Workbook
For Each WB In Application.Workbooks
WB.Save
Next WB
Application.Quit