Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

VB Script to copy selected value to clipboard


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.

2 Replies
tresesco
MVP
MVP

Try like:

Activedocument.getSheetObject("CH02").CopyValuesToClipBoard

shawn-qv
Creator
Creator

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

Or for text objects you can replace the function with CopyTextToClipboard