VBA - closing without saving changes
 

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

--
Message posted from http://www.ExcelForum.com

VBA - closing without saving changes
 

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
--
Don Guillett
SalesAid Software

"ajliaks " wrote in message
...
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 saving
changes. I need closing without saving changes!

How can I do?

Thanks,


---
Message posted from http://www.ExcelForum.com/

VBA - closing without saving changes
 

Or

ActiveWorkbook.Close False

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

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


"Don Guillett" wrote in message ...
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
--
Don Guillett
SalesAid Software

"ajliaks " wrote in message
...
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 saving
changes. I need closing without saving changes!

How can I do?

Thanks,


---
Message posted from http://www.ExcelForum.com/