Closing temp worksheet without saving
 

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

Closing temp worksheet without saving
 

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

Closing temp worksheet without saving
 

This article could be of use to you:-

http://exceltips.vitalnews.com/Pages...t_Changes.html

Hope it helps.
Mat

On Jan 25, 2:38 pm, 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

Closing temp worksheet without saving
 

Try

ActiveWorkbook.Close savechanges:=False

Mike

"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

Closing temp worksheet without saving
 

Thanks. Problem solved.