Another way to close a workbook without saving:

dim wkbk as workbook
set wkbk = workbooks("whatever.xls")
'....

wkbk.close savechanges:=false



choice wrote:

how would i go about having a code that closes the worksheet, and does NOT
save it

--

Dave Peterson