what is the code to close a file for a macro
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 |
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 |
what is the code to close a file for a macro
or staying along the lines of your original code: ActiveWindow.Close (False) |
All times are GMT +1. The time now is 03:52 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com