how to supress clipboard notice?
 

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

how to supress clipboard notice?
 

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

how to supress clipboard notice?
 

THANKS!!