Closing workbook without saving clipboard

[mcalex]

Can someone point out to me how to do this? I have copied a large
range, and pasted it to a destination workbook. I go to close the
source workbook and have to answer a dialog asking me if i want to
save the clipboard data (which I don't as it's already pasted). My
question is, how do I programmatically tell this box that, or avoid it
appearing in the first place? I get no difference in my recorded
macro code when I do this, or do it without a large amount of data
being saved on the clipboard (and hence, no dialog). I can't find any
clipboard methods that might be useful, and workbook.close
saveChanges:= false doesn't work.

Any suggestions??

Thx
mcalex

 

[Vasant Nanavati]

Application.CutCopyMode = False

will clear the clipboard.