I have written a macro that collects data from dozens of data files into a
single workbook. Every time the macro closes one of the data files I get an
automatic message window that says "There is a large amount of data on the
clipboard. Do you want to save for future applications?" and I must manually
click 'no' dozens of times in this 'automatic' macro.

How do I disable this message window so that it doesn't disrupt my macro?

Application.DisplayAlerts = False
' code the would evoke the message

Application.DiplayAlerts = True

--
Regards,
Tom Ogilvy

"Jason Griesbach" <Jason wrote in
message ...
I have written a macro that collects data from dozens of data files into a
single workbook. Every time the macro closes one of the data files I get
an
automatic message window that says "There is a large amount of data on the
clipboard. Do you want to save for future applications?" and I must
manually
click 'no' dozens of times in this 'automatic' macro.

How do I disable this message window so that it doesn't disrupt my macro?

Tom Ogilvy's solution disables the warnings.

when you're done with the CB you can clear the
clipboard with a simple application.cutcopymode=false
before closing the file.



keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


?B?SmFzb24gR3JpZXNiYWNo?= <Jason
wrote:

I have written a macro that collects data from dozens of data files
into a single workbook. Every time the macro closes one of the data
files I get an automatic message window that says "There is a large
amount of data on the clipboard. Do you want to save for future
applications?" and I must manually click 'no' dozens of times in this
'automatic' macro.

How do I disable this message window so that it doesn't disrupt my
macro?