first you can open the workbook in readonly mode to make sure no changes are
made to the workbook. Second when you save the workbook use

set bk = workbooks.open(filename:="book1.xls")

'your code here


bk.close savechanges:=False


"Tyven Bong" wrote:

How to make macro to close a workbook without save any changes that made
before the function CLOSE.