Generating Images (Gauges)

[#1]

I've figured out how to generate images for charts. The problem now is with Gauges, they generate an image per Gauge (which makes sense, because it's per objectID that I loop through to Export). The Gauges "loses" their label so makes it a bit difficult to figure out which is which.

I was wondering if there's a way to group these gauges so that when I export to bitmap through the macro, that the group of 4 gauges generates as ONE image?

[#2]

Maybe generating image of the Sheet might help.

[#3]

How would I be able to do/test that?

[#4]

sub SaveSheetImage

ActiveDocument.Sheets("Main").ExportBitmapToFile "C:\MyImage.bmp"

end sub

[#5]

That does help, but the image has a lot of white space, is there anyway to crop it to be as big as whatever is visible (so if the guages is 100px in height, not to show 100px + 600px of white space)

[#6]

That's a strictly VBA macro question. You can get better help on a VBA dedicated forum.

[#7]

Even though it might be a VBA Macro question, the reason why I asked it here is because I'm not sure if QlikView's object has like power point has:

  .PictureFormat.CropLeft = 10
  .PictureFormat.CropTop = 10
  .PictureFormat.CropRight = 10
  .PictureFormat.CropBottom = 10