topic Macro for exporting object as image? in QlikView

Macro for exporting object as image?

Fri, 30 Mar 2012 08:52:03 GMT

Hi all,

I need help with a macro for exporting object to .JPG image.

I have a Dashboard with various gauge charts that needs to be exported to .JPG for presentation externally. In the best of worlds it's possible to export two (2) objects to one (1) image (.JPG). Any help is welcome regarding macro or other ways to achieve this!

Best regards

Torbjörn Ungvall (@Ungvall)

Senior Business Discovery Manager @ Advectas AB

Macro for exporting object as image?

Mon, 02 Apr 2012 06:38:29 GMT

hi,

Try This:

This can export all object of current sheet but seperately...

Sub ExpBmp

set sh = ActiveDocument.ActiveSheet

for i = 0 to sh.NoOfSheetObjects-1

set obj = sh.SheetObjects(i)

obj.ExportBitmapToFile "MyImage"&i&".bmp"

End Sub

Regards,

Arun Goel

Re: Macro for exporting object as image?

ashfaq_haseeb — Mon, 16 Jun 2014 08:54:20 GMT

Hi,

look at the attached application.

Regards

ASHFAQ