How to avoid message about leaving data in clipboard?

[modytrane]

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.
modytrane

[Domski]

Does this work?

Please Login or Register  to view this content.

Dom

[Domski]

Or even better:

Please Login or Register  to view this content.

[modytrane]

Thanks,
That does the trick.
I appreciate yoru response.

modytrane