VBA assistance to save changes and quit application.

Hi All

I have the following code that is supposed to automatically quit the application, yet doesn't.
Any ideas where I am going wrong.

Please Login or Register  to view this content.

I've tried various options but the save prompt still comes up.

Ignore considering post #2 but try setting the Saved property of the Active workbook to True.

Hi Cytop

Thanks for response. I have tried

Please Login or Register  to view this content.

I found this code that seems to work:

Please Login or Register  to view this content.

Whatever works for you but would question

Originally Posted by Post#1

ActiveWorkbook.Save

Originally Posted by post#4

ActiveWorkbook.Close SaveChanges:=False

and including that AFTER an Application.Quit statement...

Yeah, that does not seem correct?

I have attached my workbook if someone is interested in having a look. Can't seem to find an alternative.