ActiveWorkbook.Close savechanges:=false
or
ActiveWorkbook.Close False



JanB wrote:

Hope somebody is able to help.

I have created an macro where I am opening and using an workbook, and
then closing it again without saving it. The problem is that I cannot
close the workbook without having to clik save-yes or save-no. I do
still need to have som other excel sheets open.

I have tried to use the following code:
ActiveWorkbook.Close = False

--

Dave Peterson