I'm copying large amount of data from one spreadsheet to another. Then
I close the Workbook.

wb1.Close SaveChanges = False

I then get a dialog box asking me if I want to save the data on the
clipboard or not. I want to choose automatically (via VBA) to not save
the contents on the clipboard.

Sorry I'm just a novice at VBA......but getting better.

Tony


--
ajocius
------------------------------------------------------------------------
ajocius's Profile: http://www.excelforum.com/member.php...o&userid=17695
View this thread: http://www.excelforum.com/showthread...hreadid=389549