Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
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.
It is possible to fully automate reports generation from Qlikview (Both PDF and Excel)
See below link -