Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everybody,
I want to create a macro to copy the cell value (on select) from the table box and paste it to the clipboard.
Please suggest.
Thanks In Advance
Sonali
ActiveDocument.GetSheetObject("CH01").CopyValuesToClipboard
Will not work in WebView (Ajax), only in plugin.
why do you need a macro when you can right-click and select copy->cell value?
Hi Ali,
Yes, there is the option of coping a value, right click- copy- cell value- paste
But I want to reduce the number of actions performed. Hence I want to create a trigger so that when I click a field value it will automaticall copy the selected value.
ActiveDocument.GetSheetObject("CH01").CopyValuesToClipboard
Will not work in WebView (Ajax), only in plugin.
but you need to pay attention that macros do not work in browsers like google Ghrome and in IE unless you have the IE plug in installed
>but you need to pay attention that macros do not work in browsers like google Ghrome and in IE unless you have >the IE plug in installed
This is incorrect.
All macros does not work in Ajax, but a lot of them.
CopyValuesToClipboard does not work since you can't access the clipboard in Ajax.
Hi Jerry,
Thanks for your help..
I am using IE plug In for this work but still it is not working.
What will be the actual code?
ActiveDocument.GetSheetObject("CH01").CopyValuesToClipboard
Or do I have to create a variable and pass this variable under Sub End Sub
It should work if your tablebox has the ID CH01.
I tested it in Developer and it worked fine, can't try it in plugin since we only use Ajax as client.
Hi, Thanks for the solution, can you please advise a way by which I can copy data with Header. I used below code
Sub Copy
ActiveDocument.GetSheetObject("CH01").CopyValuesToClipboard
End sub