Hi,

How do i get my marcos to automatically clear the clipboard when closing a
file. Currently, the macros close a csv file once the contents have been
copied into a central sheet. I am then faced with the question "There is a
large amount of data in the clipboard, would you like to keep it.........."

Once macro does this to 15 files and it is really annoying to have to keep
clicking 'No' when i run it.

Any help is much appreciated

Cheers

Greg