i want to export qlikview objects from multiple sheets to excel using macros

[#1]

hi,

i want to export qlikview objects which are present in multiple sheets to excel using macros.

we can only export the active objects in a sheet, but is it possible to export the object the other sheets also to excel using macros on button click?

can anyone help me?

[fosuzuki]

Hi,

If you want to change the active sheet via macro, use the code:

ActiveDocument.ActivateSheet 1

or

ActiveDocument.ActivateSheetByID "SH01"

If you want to loop through a list of objects:

Objects = ActiveDocument.ActiveSheet.GetSheetObjects

For i = lBound(Objects) To uBound(Objects)

   If Objects(i).GetObjectType = 10 Then   'pivot tables

     'do your thing here....

    end if

next

These sample codes are available in the APIGuide.

Hope this helps you.

Regards,

Fernando