the point is i really don't user to save the file, any method?

thanks

Frank Kabel wrote:

Hi
one way: put the following in the workbook_beforeclose event:

activeworkbook.saved = true