VBA-Excel Disable Clipboard on close 1

[vaneagle]

Having issue with a macro where part of the process the macro copies data, and pastes into another file. No issue here. But when I go back to the source file and close the file it gives me the usual:

"There is a large amount of info on the clipboard. Do you want to be able to cut and paste this info into another program later?"

Is there something missing from the code below so that I can have the script say 'No'

ActiveWorkbook.Close

is there a better way to close the file so that it won't bring up the dialog box mention above???

 

[sfvb]

Probably the easiest way is just to overwrite the clipboard with no data:

Sub TestClipBoardMsg()
   Dim JunkData     As New DataObject

'Put your code for copying and pasting here
   
   'Code to stop Clipboard message

   JunkData.SetText ""
   JunkData.PutInClipboard
End sub

 

[vaneagle]

Excellent!!!

Thanks very much for that...

Saves me having to click no for every file i close with the code....