Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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