Clear clipboard

[#1]

Does anyone know how to clear the clipboard after you copy a table? I am using:

ActiveDocument.GetSheetObject("CH09").CopyTableToClipboard true

XLDoc.Sheets(1).Paste()

But now I need to clear the clipboard and copy a different object. Help?

[Anonymous]

I don't think there's a direct approach to clearing the clipboard using vbscript.

Why don't you just copy the next object and it will overwrite CH09 on the clipboard?

[#3]

That's what is weird. When I copy the next object, it doesn't override the last object and pastes the original object instead. The only solution I can think is to somehow clear the clipboard or use two macros, which I would prefer to avoid.