Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Macro for exporting object as image?

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

Tags (1)
2 Replies
Not applicable

Macro for exporting object as image?

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"

next

End Sub

Regards,

Arun Goel

Re: Macro for exporting object as image?

Hi,

look at the attached application.

Regards

ASHFAQ

Community Browser