loop through charts using macro

ali_hijazi — Tue, 24 Jun 2014 08:20:48 GMT

hello

I'm using QlikView 11.2

I want to loop through all available charts of the active sheet

I'm writing the following macro

Sub GetCharts

Objects = ActiveDocument.ActiveSheet.GetSheetObjects

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

If obj.GetObjectType = 11 Then

msgbox("Chart: " & obj.GetObjectId)

End If

End Sub

however when I call this macro from a button the Edit Module opens and nothing happens

please advise

Re: loop through charts using macro

Gysbert_Wassenaar — Tue, 24 Jun 2014 09:07:57 GMT

See this discussion for some example code that loops through sheet objects: Re: Load help text of objects