I am creating a program that opens an excel file on the network, copies data from a worksheet from that workbook on to ThisWorkbook and then closes the workbook on the network.
Everything seems to work fine except that when I close the workbook on the network, it displays a message asking if I want to leave the data on the clipboard for future use.
What code do I need to avoid getting this message? I would like to close the workbook without leaving anything in the clipboard, but I don't want the user to see this message.
Here's the code that opens the workbook and copies data.
Please Login or Register to view this content.
I am sure there is probably a more efficient way to do this and avoid getting the message.
Thanks for any help I can get.