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

Fri, 20 Jan 2012 13:58:52 GMT

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?

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

fosuzuki — Mon, 23 Jan 2012 20:58:41 GMT

Hi,

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

ActiveDocument.ActivateSheet 1

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

These sample codes are available in the APIGuide.

Hope this helps you.

Regards,

Fernando

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

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

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