Prev: Printing
Next: Is there anyway of using a calendar similar to the VB version in e
From: Celia on 1 Apr 2010 22:23
I need to close a file in a macro but I am not sure how to do it. I could
use the following but when I use this a pop up screen says do you want to
save the changes to the file. I don't want to save the changes. Is there
any code to use that will eliminate the pop up asking me to save the file.

ActiveWindow.Close



----
Celia
From: ozgrid.com on 1 Apr 2010 22:42
Worbooks("Book.xls").Close SaveChanges:=False



--
Regards
Dave Hawley
www.ozgrid.com
"Celia" <Celia(a)discussions.microsoft.com> wrote in message
news:99DDAB63-FAFE-4276-9EE7-0288AE465B4E(a)microsoft.com...
>I need to close a file in a macro but I am not sure how to do it. I could
> use the following but when I use this a pop up screen says do you want to
> save the changes to the file. I don't want to save the changes. Is there
> any code to use that will eliminate the pop up asking me to save the file.
>
> ActiveWindow.Close
>
>
>
> ----
> Celia

From: arjen van der wal on 1 Apr 2010 22:55

or staying along the lines of your original code:

ActiveWindow.Close (False)
 | 
Pages: 1
Prev: Printing
Next: Is there anyway of using a calendar similar to the VB version in e