Copy data from Specific Cells of Table - Macro ?

[#1]

All,

Can anyone advise how i can copy text from a specific cell without going through the right click -> Copy to Clipboard -> Cell Value.

For my usecase the whole right click process is too time consuming as this has to be done multiple times a day. Can anyone advise a better approach

Would i need to write a macro for this ?

Thanks

[Gysbert_Wassenaar · Accepted solution]

The only alternative is using a macro. But the macro needs to be passed the row and column of the cell. There is no click event that can be used. None. So, that's probably just as much work. See here for some examples.

Of course you could just copy all the table data and delete what you don't need from the document where you paste it.

edit: an example

Sub A

    msgbox ActiveDocument.GetSheetObject( "CH01" ).GetCell(2,3).text

end sub

[#3]

Thanks, any idea what that maco would look like ?