Help Needed - QV8.0 Buttons

[#1]

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

[#2]

According to the API Guide, this should work:

ActiveDocument.GetSheetObject("CH01").CopyBitmapToClipboard

Where CH01 is the Object ID.

[#3]

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

[#4]

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.