Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Closing sheets and selecting 'no' automatically
Hi, I have some code which collects data from various different workbooks on
a network then applied some formating and prints them. When the stuff has been printed I just simply want to close the workbook without saving the changes. Now even if i set Application.DisplayAlerts to false while this part runs can I be sure that the default is not to save them, i.e. the focus is not on the yes button. Does anyone know anything about this. Thanks for your time. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Closing sheets and selecting 'no' automatically
Graham Whitehead wrote: Hi, I have some code which collects data from various different workbooks on a network then applied some formating and prints them. When the stuff has been printed I just simply want to close the workbook without saving the changes. Now even if i set Application.DisplayAlerts to false while this part runs can I be sure that the default is not to save them, i.e. the focus is not on the yes button. Does anyone know anything about this. Thanks for your time. have look he http://www.vbcity.com/forums/topic.asp?tid=29144 this is way to close without saving |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Closing sheets and selecting 'no' automatically
something equivalent to
Activeworkbook.Close Savechanges:=False would be the easiest. If it isn't the activeworkbook, substitute a reference to the workbook you want to close. -- Regards, Tom Ogilvy "Graham Whitehead" wrote: Hi, I have some code which collects data from various different workbooks on a network then applied some formating and prints them. When the stuff has been printed I just simply want to close the workbook without saving the changes. Now even if i set Application.DisplayAlerts to false while this part runs can I be sure that the default is not to save them, i.e. the focus is not on the yes button. Does anyone know anything about this. Thanks for your time. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Closing sheets and selecting 'no' automatically
Graham Whitehead wrote: Hi, I have some code which collects data from various different workbooks on a network then applied some formating and prints them. When the stuff has been printed I just simply want to close the workbook without saving the changes. Now even if i set Application.DisplayAlerts to false while this part runs can I be sure that the default is not to save them, i.e. the focus is not on the yes button. Does anyone know anything about this. Thanks for your time It isn't really a matter of focus on a button, but a matter of bypassing the 'are you sure?' dialogs. if you set your alerts to false and your code is programmed to save your file with a name that already exists, it will overwrite the existing file - no questions asked if your alerts are set to false and you close your workbook, it will not ask if you want to save your changes - no questions asked. (so if you do, be sure that you have already done so in your code) hope this helps AR |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Closing sheets and selecting 'no' automatically
Cheers ducky, just the info I was looking for.
"ducky" wrote in message ps.com... Graham Whitehead wrote: Hi, I have some code which collects data from various different workbooks on a network then applied some formating and prints them. When the stuff has been printed I just simply want to close the workbook without saving the changes. Now even if i set Application.DisplayAlerts to false while this part runs can I be sure that the default is not to save them, i.e. the focus is not on the yes button. Does anyone know anything about this. Thanks for your time It isn't really a matter of focus on a button, but a matter of bypassing the 'are you sure?' dialogs. if you set your alerts to false and your code is programmed to save your file with a name that already exists, it will overwrite the existing file - no questions asked if your alerts are set to false and you close your workbook, it will not ask if you want to save your changes - no questions asked. (so if you do, be sure that you have already done so in your code) hope this helps AR |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Set macro to run automatically when closing workbook? | Excel Discussion (Misc queries) | |||
automatically close form before closing | Excel Discussion (Misc queries) | |||
Automatically closing workbook | Excel Programming | |||
closing userform automatically | Excel Programming | |||
Closing Dataform automatically | Excel Programming |