Macro

[#1]

HI,

I need to copy Qlikview chart value into clipboard and need to get that value in Qlivkiew.I wrote macro as

sub Test

ActiveDocument.GetSheetObject("CH131").CopyTableToClipboard true

This will copy chart 131 value into Clipboard.

I am not getting how to paste it in Qlikview.

Can anyone please help ASAP.

[tresesco]

Where do you want it to paste? QlikView sheet? I guess that is not possible. You can rather export it to excel or so like:

Doc.GetSheetObject(var).CopyTableToClipBoard TRUE

xlApp.ActiveSheet.Paste

[jagan]

Hi,

Where you want to Paste this?  Just press Ctrl+ v as the value is on clipboard.  or check for Send keys in macro.

SendKeys "^ve~"

Regards,

Jagan.