View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default 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/