Macro - automate copy then close

  • Thread starter Thread starter Skip
  • Start date Start date
S

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.
 
Have you tried
application.displayalerts=false
your code
application.displayalerts=true
 
Back
Top