| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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"? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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"? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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"? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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"? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to save and close, then copy file | Excel Discussion (Misc queries) | |||
| How to code the Macro to save and close a file? | Excel Discussion (Misc queries) | |||
| Close & save a file at set time only IF the file is open | Excel Programming | |||
| CLOSE ALL macro for XL2K (but with prompt to save for each file)? | Excel Programming | |||
| Automate open file, update links, run macro, close and save file | Excel Programming | |||
Linear Mode
