VBA Syntax Delete data from Clipboard before closing a file

[mrfobking]

I recorded a Macro to open a workbook, copy and paste data from one excel workbook to another, and close the workbook which was opened. Everything works fine except:

because of the amount of data that I am copying, I get a message box saying "There is a large amount of information on the Clipboard. Do you want to be able to paste this information into another prgoram later?" with a Yes/No button.

So now I have to click the "No" button before my macro closes the excel file. Is there a simple line of code that will by-pass this?

I am assuming it has to do with the following:

Windows("Book1.xls").Activate
ActiveWindow.Close , savechanges:=False

Please let me know any one knows of a quick solution to this question. Your help is appreciated.

 

[jim may]

Try:

Application.CutCopyMode = False

HTH

 

[mrfobking]

thanks... it works

 

[jim may]

Thanks always for the feedback

 

[DaVinci]

Thanks Jim. Your answer helped me, too!

 

[Kkothari]

Try:Application.CutCopyMode = FalseHTH

What would be the code to select Yes instead of No?