How do I get excel to use the application.quit function
without wanting to save before exit

Thanks

Greg

ThisWorkbook.Saved = True
Application.Quit

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Greg" wrote in message
...
How do I get excel to use the application.quit function
without wanting to save before exit

Thanks

Greg

Thanks Bob works great

Greg
"Bob Phillips" wrote in message
...
ThisWorkbook.Saved = True
Application.Quit

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Greg" wrote in message
...
How do I get excel to use the application.quit function
without wanting to save before exit

Thanks

Greg

ActiveWorkbook.Close False ' False here means do not save changes
Application.Quit
--
- K Dales


"Greg" wrote:

How do I get excel to use the application.quit function
without wanting to save before exit

Thanks

Greg

Application.DisplayAlerts = False
Application.Quit

If DisplayAlerts is False, Excel will not prompt you to save any unsaved
data, nor will it actually save anything.

--
Hmm...they have the Internet on COMPUTERS now!


"Greg" wrote:

How do I get excel to use the application.quit function
without wanting to save before exit

Thanks

Greg