Thread: what is the code to close a file for a macro
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
ozgrid.com ozgrid.com is offline
external usenet poster
  
Posts: 464
Default what is the code to close a file for a macro
Worbooks("Book.xls").Close SaveChanges:=False



--
Regards
Dave Hawley
www.ozgrid.com
"Celia" wrote in message
...
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

Reply With QuoteReply With Quote