clear the copied text before closing?

[TravisLaborde]

I have a Word Document, which uses VBA, to open various other Word Documents, based on data, and copies their text, then paste's that text into a newly created document.

At the end of the macro, the various "source" documents are closed, and only the newly created "Document1" is left open. This all works fine, but...

When the users exit this document, they get the prompt "You have placed a large amount of data into the Clipboard... etc... Do you want to .... etc.?"

Is there a way for me to clear that beforehand, in my VBA, so that the user does not get this message?

Thanks,
Travis

 

[PaulTEG]

I don't know about dumping the clipboard but I can suggest a workaround.

This error only pops up when a large amount of data has been posted, so copy a blank cell to the workbook before closing

HTH

;P

 

[TravisLaborde]

LOL, sometimes the solution is simple

Thanks!
Travis