VBA to delete clipboard contents and proceed with VBA

[adamlscott]

This should be a simple one but I can't figure it out.

I have some very basic code that does the following:

(Workbook "X" is already open)

Open Workbook "A"
Copy Range
Activate Workbook "X"
Paste Range from "A"
Close WorkBook "A"

Open Workbook "B"
Copy Range
Activate Workbook "X"
Paste Range from "B"
Close WorkBook "B"

It does this for quite a few workbooks and saves me a good amount of time.

My problem is that as the workbooks close a dialog box appears alerting me that there is alot of info on the clipboard and whether I want to save it or delete it. I just want to delete it but I'd like to make that decision via code rather then wait for the dialog box to open. I'd like to insert a line of code after the close workbook line that will tell excel that I don't want to save the contents of the clipboard.

Any suggestions?

 

[Datsmart]

This link has code to clear/empty the clipboard.
http://www.cpearson.com/excel/clipboar.htm

 

[adamlscott]

Thanks Datsmart for the link. It didn't answer my question but it did lead me to a link that did.

All I have to do is have a line before closing the workbook that states:

Application.CutCopyMode = False

Thanks again for the link.

 

[Datsmart]

OK, that makes sense.

Thanks for the reply.