Discussion Board for collaboration related to QlikView App Development.
For a certain QV documentI need to create a macro to copy a field value to the clipboard so it can be used in another application. The macro I created works perfect in the local desktop client (8.5) but it refuses to work by using the ActiveX browser plugin.
set ContractNr = ActiveDocument.fields("Contract_Number").GetSelectedValues
If ContractNr.Count=1 Then
Msgbox("Select one value.")
The macro partly works though the ActiveX plugin and does result in an message when not selecting one single value. But the problem is that no value is copied to the clipboard. Is there a solution for this problem.
Another thing I have noticed is that when pressing the right mouse button on a text object to see the menu. The option/menu "Copy to Clipboard" is grayed out.
Some QV APIs don't work as expected in this situation. See if you can get the value to the clipboard using VBscript functionality rather than QV API.
Thanks for your answer. I'm already using a VBscript macro to copy a textvalue to the clipboard. The problem is it doesn't work through the ActiveX plugin. The fact that the Copy (right mousbutton) meny is grayed out could have something to do with document/user/server settings, the problem is I can't find the solution.. Hope somebody can help me.
That solved my problem. You are the best...