VBA - closing without saving changes

[ajliaks]

Hi,

This is very simply!

I am using the instruction

ActiveWorkbook.Close

to close file.

I need the macro cloosing the active workbook without asking for savin
changes. I need closing without saving changes!

How can I do?

Thanks

 

[Don Guillett]

try
ActiveWorkbook.Close saveD=true

OR
This example closes the workbook that contains the example code and discards
any changes to the workbook by setting the Saved property to True.

ThisWorkbook.Saved = True
ThisWorkbook.Close

 

[Ron de Bruin]

Or

ActiveWorkbook.Close False

This is the same as
ActiveWorkbook.Close SaveChanges:=False

--
Regards Ron de Bruin
http://www.rondebruin.nl

try
ActiveWorkbook.Close saveD=true

OR
This example closes the workbook that contains the example code and discards
any changes to the workbook by setting the Saved property to True.

ThisWorkbook.Saved = True
ThisWorkbook.Close