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

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

Application.DisplayAlerts = False
Activeworkbook.Close SaveChanges:=False
Application.DisplayAlerts = True

or similar to as Steve suggest

Activecell.copy
Activeworkbook.Close SaveChanges:=False

Or as Steve suggested
Application.CutcopyMode = False
Activeworkbook.Close Savechanges:=False

--
Regards,
Tom Ogilvy


" 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