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