macro to close file and not save changes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a "helper" file that opens, performs some tasks and then closes in a
macro, but before it closes, a pop up window appears and asks if I want to
save changes...I do not. Is there a code I can use so that that pop up
window does not appear or to automatically select "no"?
 
Assuming you are using the active workbook to reference you helper file then
this will do it

ActiveWorkbook.Close SaveChanges:=False

or otherwise

Workbooks("Whatever").Close SaveChanges:=False
 
Thanks Jim, that is what I was looking for...I also needed to ask on the
opening, it states that the file already exists, do you want to replace file,
I want to select yes. Do you know the code for that one?
 
I am a little lost with on the openeing and replace existing but you can try

Application.DisplayAlerts = false
'your code
Application.Displayalerts = true
 
Back
Top