How do I close a file without saving the changes? I am using
ActiveWorkbook.close - is there a parameter I can add onto the end of this
statement?

MB

You can either set

application.displayalerts to false

or there is the specific setting of

ActiveWorkbook.saved = true which, if set without having actually saved
the file, causes Excel to quit without prompting...

Hope these help

David


"mb" wrote in message
...
How do I close a file without saving the changes? I am using
ActiveWorkbook.close - is there a parameter I can add onto the end of this
statement?

MB

Hi mb

ActiveWorkbook.Close SaveChanges:=False


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"mb" wrote in message ...
How do I close a file without saving the changes? I am using
ActiveWorkbook.close - is there a parameter I can add onto the end of this
statement?

MB

Sub CloseMe()
ActiveWorkbook.Close SaveChanges:=False
End Sub

The 'False' bit tells it not to save before closing

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
Best wishes to all, and hope for a good New year :-)
----------------------------------------------------------------------------



"mb" wrote in message
...
How do I close a file without saving the changes? I am using
ActiveWorkbook.close - is there a parameter I can add onto the end of this
statement?

MB




---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.557 / Virus Database: 349 - Release Date: 30/12/2003

You can write :

ActiveWorkbook.Close False

Juha

-----Original Message-----
How do I close a file without saving the changes? I am
using
ActiveWorkbook.close - is there a parameter I can add
onto the end of this
statement?

MB


.

Hi MB

ActiveWorkbook.close savechanges:=false

Wolf
-----Original Message-----
How do I close a file without saving the changes? I am
using
ActiveWorkbook.close - is there a parameter I can add
onto the end of this
statement?

MB


.