Closing temp worksheet without saving

[JanB]

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]

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

 

[Matt Richardson]

This article could be of use to you:-

http://exceltips.vitalnews.com/Pages/T0161_Saving_Non-Existent_Changes.html

Hope it helps.
Mat

 

[Mike H]

Try

ActiveWorkbook.Close savechanges:=False

Mike

 

[JanB]

Thanks. Problem solved.