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

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

How can I get an excel macro to close without saving !
 

Try
Application.Quit

Regards
Nigel

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

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