how to supress clipboard notice?

[Guest]

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

 

[Jake Marx]

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]

 

[Guest]

THANKS!!