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