macro to close file and not save changes
 

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"?

macro to close file and not save changes
 

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
--
HTH...

Jim Thomlinson


"DB74" wrote:

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"?

macro to close file and not save changes
 

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?

"Jim Thomlinson" wrote:

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
--
HTH...

Jim Thomlinson


"DB74" wrote:

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"?

macro to close file and not save changes
 

I am a little lost with on the openeing and replace existing but you can try

Application.DisplayAlerts = false
'your code
Application.Displayalerts = true
--
HTH...

Jim Thomlinson


"DB74" wrote:

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?

"Jim Thomlinson" wrote:

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
--
HTH...

Jim Thomlinson


"DB74" wrote:

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"?