| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I get an excel macro to close without saving !
I have worksheets email to me. I want to have a simple macro to close them
without saving them, to keep the integrity of what was emailed to me. Is there a way of doing this ?? thanks ... Roger |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How can I get an excel macro to close without saving !
Try
Application.Quit Regards Nigel |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How can I get an excel macro to close without saving !
Great, many thanks guys
Roger "Nigel" wrote in message oups.com... Try Application.Quit Regards Nigel |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How can I get an excel macro to close without saving !
"Roger O" schrieb im Newsbeitrag ... I have worksheets email to me. I want to have a simple macro to close them without saving them, to keep the integrity of what was emailed to me. Is there a way of doing this ?? thanks ... Roger Hi Roger, try application.DisplayAlerts= False Workbooks("whatever").Close application.DisplayAlerts= true cheers, Stephan |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How can I get an excel macro to close without saving !
"Dr. Stephan Kassanke" schrieb im Newsbeitrag ... "Roger O" schrieb im Newsbeitrag ... I have worksheets email to me. I want to have a simple macro to close them without saving them, to keep the integrity of what was emailed to me. Is there a way of doing this ?? thanks ... Roger Hi Roger, try application.DisplayAlerts= False Workbooks("whatever").Close application.DisplayAlerts= true cheers, Stephan or more elegant Workbooks("whatever").Close SaveChanges:=False cheers, Stephan |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to Prompt User to Close After Saving | Excel Discussion (Misc queries) | |||
| Am i the first person to close and excel file, without saving chan | Excel Discussion (Misc queries) | |||
| close excel without saving | Excel Programming | |||
| Open/Close Event and Excel Saving process | Excel Programming | |||
| Auto close excel without saving | Excel Programming | |||
Hybrid Mode
