closing and not leaving data on clipboard

[Robert Paul]

Hi,

I am automating a data collection process (i.e. gather data from various spreadsheets and deposit them in a central location).

When my code closes a file, a prompt appears saying (paraphrasing): You have a large amount of data on a clipboard. Do you want to keep it there for future use.

How do I answer "no" to this question in my code such that the code automatically closes the file and moves onto the next file?

Thanks for your support,
Robert

 

[DominicB]

Good afternoon Robert Paul

Bad news : It's not an easy task to just clear the clipboard. You need to make complicated API calls.

Good news : Chip Pearson shows you exactly how to do it here :

http://www.cpearson.com/excel/clipboar.htm

HTH

DominicB

 

[andshep]

Can't you just add the following into your code before you close the source file?

Application.CutCopyMode = False

 

[Absolution]

This worked perfectly for me, stopped the pesky monster from asking silly questions on exit

Can't you just add the following into your code before you close the source file?

Application.CutCopyMode = False