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.

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

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.

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

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