Automatically empty the Clipboard after pasting information

[wabahn]

I have a simple macro that opens an WorkbookA, copies worksheetA, pastes the data into worksheetB in workbookB, then closes the workbookA. On closing of workbookA, I want to automatically clear the clipboard and not be prompted as to whether I want to keep the data on the clipboard. How do I do this?

 

[Andrzejek]

DisplayAlerts = False

And you will not be prompted

To clear the clipboard you can simply point to an empty cell and copy it.

Have fun.

---- Andy

 

[wabahn]

Thanks Andy - I was making it much more complicated than it needed to be.