Macro - automate copy then close

[Skip]

Hi,

I've created a Macro using the Macro Recorder which opens a CSV file, copies
data, closes the CSV file and then pastes the data into another workbook.
The problem is each time the CSV files close I get a message 'There is a
large amout of information on the Clipboard. Do you want to be able to paste
this information into another program later?' Possible responses Yes, No or
Cancel.

The answer is always 'Yes'. Can I automate the response by adding anything
to the Macro?

Appreciate any help.

Many thanks.

 

[Don Guillett]

Have you tried
application.displayalerts=false
your code
application.displayalerts=true

 

[Don Guillett]

glad to help

 

[Skip]

Many thanks. Works a treat.