Closing a window after transferring data
 

I have a file from which I have done a copy/paste for a fair amount
of data. I have a macro to do this, and wish to close the window
totally. However when I use:

ActiveWorkbook.Close

I get a message asking whether I want to save the data on the
clipboard. I have looked in "help" for options to supress this
message, but cannot find them.Can someone give me the answer please.
Question is: How do I set the macro to avoid this message when
closing!!

Thanks in advance

John Baker

Closing a window after transferring data
 

hi
usually the best method is to turn off alerts at the begining of the macro
then turn them back on at the end.

Application.DisplayAlerts = False
your code here
ActiveWorkbook.Close
Application.DisplayAlerts = True

regards
FSt1

"JHB" wrote:

I have a file from which I have done a copy/paste for a fair amount
of data. I have a macro to do this, and wish to close the window
totally. However when I use:

ActiveWorkbook.Close

I get a message asking whether I want to save the data on the
clipboard. I have looked in "help" for options to supress this
message, but cannot find them.Can someone give me the answer please.
Question is: How do I set the macro to avoid this message when
closing!!

Thanks in advance

John Baker

Closing a window after transferring data
 

On Aug 2, 9:12*pm, FSt1 wrote:
hi
usually the best method is to turn off alerts at the begining of the macro
then turn them back on at the end.

Application.DisplayAlerts = False
your code here
ActiveWorkbook.Close
Application.DisplayAlerts = True

regards
FSt1

"JHB" wrote:
I *have a file from which I have done a copy/paste for a fair amount
of data. I have a macro to do this, and wish to close the window
totally. However when I use:

ActiveWorkbook.Close

I get a message asking whether I want to save the data on the
clipboard. I have looked in "help" for options to supress this
message, but cannot find them.Can someone give me the answer please.
Question is: How do I set the macro to avoid this message when
closing!!

Thanks in advance

John Baker

Thanks..very helpful!