Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Thanks, any idea what that maco would look like ?