export QlikView Objects to *.BMP

[thierrytt1102]

Hello,

I have a problem here trying to export QlikView Objects to images.

I developped this macro:

sub Exportation

ActiveDocument.ClearAll

DocSheet = ActiveDocument.Sheets("Sheet").Activate

Objects = ActiveDocument.ActiveSheet.GetSheetObjects

FOR i = lBound(Objects) TO uBound(Objects)

SET obj = Objects(i)

obj.ExportBitmapToFile "C:\ "&i&".bmp"

next

end sub

It works fine but I'd like to:

1. take the objects of every sheets

2. rename the file with the name of the object.

Does anyone can help me?

Thanks a lot.

[#2]

Hey thanks for the response.

I am using stacked bar charts so there quite a number data points. An average of around 30 on each chart.

I've tried this code and it seems to be working correctly thus far:

set APP = ActiveDocument.GetApplication

                     set c=ActiveDocument.GetSheetObject("CH158")

                      APP.WaitForIdle

                      APP.Sleep 1000

                     c.Restore

                      APP.WaitForIdle

               APP.Sleep 1000

               ActiveDocument.ClearAll

               APP.WaitForIdle

               APP.Sleep 1000

               ActiveDocument.RecallDocBookmark "Slide2"

               APP.WaitForIdle

               APP.Sleep 1000

                        ActiveDocument.GetSheetObject("CH158").ExportBitmapToFile "C:\Insight\PPT Images\MetCash\" & "001 National - National - LAD’s by Manufacturer Share.bmp"