VB Script to copy selected value to clipboard

[Anonymous]

Hi

Please can anyone tell me how to do this?

I want to copy a selected value in a specific field to the clipboard so that I can paste it into a word document. I want to do this using vb script as my macro sends a bunch of tables to word.

[tresesco]

Try like:

Activedocument.getSheetObject("CH02").CopyValuesToClipBoard

[shawn-qv]

For list or tables, you can try ActiveDocument.GetSheetObject("ID").CopyValuesToClipboard

Or for text objects you can replace the function with CopyTextToClipboard