topic Help Needed - QV8.0 Buttons in QlikView

Help Needed - QV8.0 Buttons

Tue, 19 Jan 2010 17:54:48 GMT

Hi all,

I was wondering if anyone knew how to create a button which will copy a gauge chart to the clipboard as an image? I know you can right click on the sheet object and do this but would be good if i can do it in a button.

I have no VB knowledge I'm afraid!!

Thanks,

Chris

Help Needed - QV8.0 Buttons

Tue, 19 Jan 2010 18:02:01 GMT

According to the API Guide, this should work:

ActiveDocument.GetSheetObject("CH01").CopyBitmapToClipboard

Where CH01 is the Object ID.

Help Needed - QV8.0 Buttons

Tue, 19 Jan 2010 18:17:28 GMT

Thanks for this - but I can't seem to get it to work.

I select new sheet object -> button

I then select Macro as the function then select Edit Module on the macro tab and paste this code in

Am I doing something wrong? Sorry I got trained on QV 2 years ago and only just got round to using it!!!

Thanks,

Chris

Help Needed - QV8.0 Buttons

Tue, 19 Jan 2010 18:58:13 GMT

You need to make it a subroutine.

Sub CopytoBMP
 ActiveDocument.GetSheetObject("CH01").CopyBitmapToClipboard
End Sub

Then once you close the Edit Module screen, make sure you select your Sub in the macro drop down.