topic SV:Re: Copy text to clipboard in QlikView

Copy text to clipboard

Wed, 10 Jun 2009 23:45:32 GMT

Hello,

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.


Sub CopyCNR
 set ContractNr = ActiveDocument.fields("Contract_Number").GetSelectedValues
 If ContractNr.Count=1 Then
 ActiveDocument.GetSheetObject("TX03").CopyTextToClipboard
 Else
 Msgbox("Select one value.")
 End If
End Sub

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.

regards Mark

Copy text to clipboard

Anonymous — Wed, 10 Jun 2009 23:55:58 GMT

Mark,
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.

Copy text to clipboard

Thu, 11 Jun 2009 14:51:09 GMT

Michael,

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.

regards Mark

SV:Re: Copy text to clipboard

Thu, 11 Jun 2009 16:32:02 GMT

I have a similar macro which works with the plugin. Do you "allow export" on the security setting on the document? /Michael

SV:Re: Copy text to clipboard

Thu, 11 Jun 2009 16:43:09 GMT

Thanks a97mic,

That solved my problem. You are the best...

regards Mark