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

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

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 <jbo...@sol.dk> 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

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
>

Thanks. Problem solved.