Macros...

[#1]

I have a fair bit of experience preparing charts reports etc but none in VBScript... I wanted to write a Macro that copies a chart to the clipboard ready for some one to paste into presentation etc..can anyone suggest best way to do this?

[#2 · Accepted solution]

Hi,

It will depend of the way you wanna give to your users for selecting the chart to be copied, the instruction is the follow:

ActiveDocument.GetSheetObject("CH01").CopyBitmapToClipboard

You could keep the last active graph name in a variable or give the name in the code directly.

I hope this is waht you are looking for.

Best regards.

[Pravinkarne]

It is possible to fully automate reports generation from Qlikview (Both PDF and Excel)

See below link - 

https://youtu.be/GtYxpd7WUbs