Can you not just clear the clipboard first? Avoiding the messages?

Steve

" wrote:

Hi All,

I am running a macro that opens two files, copies 2500 records from one
file to the other and then one of the files is closed.

Now while closing this file, i get a message saying "There is a large
amount of data on the clipboard. Do you want to be able to paste this
information into another program later?"

Along with this it gives me yes/no and cancel buttons.

I dont want this box to appear and also clear the clipboard before the
file closes. Is there a way to do this?

I want to avoid send key..

I appreciate any help.

Thanks,
Yash