I am using a macro to copy information from a *.csv file that is generated by an application to import it into a spreadsheet and format the page. How do I supress the following message after I have executed the command to close the file that the data is copeid to and paseted into the new sheet

"There is a large amount of information on the Clipboard. Do you want to be able to paste this in another program later

-To save it on the Clipboard so that you can paste it later, click Yes
-To delete it from the Clipboar and free memory, click No.

Thanks for you hel

Sherri

Hi Sherri,

The following line of code should do the trick:

Application.CutCopyMode=False

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]


Sherri wrote:
I am using a macro to copy information from a *.csv file that is
generated by an application to import it into a spreadsheet and
format the page. How do I supress the following message after I have
executed the command to close the file that the data is copeid to and
paseted into the new sheet?

"There is a large amount of information on the Clipboard. Do you
want to be able to paste this in another program later?

-To save it on the Clipboard so that you can paste it later, click
Yes.
-To delete it from the Clipboar and free memory, click No. "

Thanks for you help

Sherri

THANKS!!