workbook object with the .close method, Excel might display a message that says There is a large amount of information on the clipboard. Do you want to be able to paste this information into another program later?:
application.displayAlerts to false. Microsoft recommends to prevent this message with one of the execute one of the following three statements before closing the workbook: activeSheet.range("a1").copy
application.cutCopyMode = false
wb.save