Application.Close
 

Hi,

I have this simple bit of code in my close macro

ActiveWorkbook.Save
Application.Quit

When this runs it comes up with the "Do you want to save changes" dialog box
when i've already saved it automatically.

Is there anyway of getting rid of the Dialog Box?

Thanks in advance

Application.Close
 

Try this//

ActiveWorkbook.Close Savechanges:=True
Application.Quit

If this post helps click Yes
---------------
Jacob Skaria


"N1KO" wrote:

Hi,

I have this simple bit of code in my close macro

ActiveWorkbook.Save
Application.Quit

When this runs it comes up with the "Do you want to save changes" dialog box
when i've already saved it automatically.

Is there anyway of getting rid of the Dialog Box?

Thanks in advance

Application.Close
 

You might also consider using

ThisWorkBook.Save SaveChanges:=True

Ensuring the workbook being saved is the one with the code.
--

Regards,
Nigel




"N1KO" wrote in message
...
Hi,

I have this simple bit of code in my close macro

ActiveWorkbook.Save
Application.Quit

When this runs it comes up with the "Do you want to save changes" dialog
box
when i've already saved it automatically.

Is there anyway of getting rid of the Dialog Box?

Thanks in advance