Object required: 's.GetActiveSheetObjects'

[#1]

Hi,

The following simple code taken from API returned the error Object required: 's.GetActiveSheetObjects'

The eror is makred on the third line.

Qlikview version 9.00 on Windows XP

sub GoDown
set s = ActiveDocument.ActiveSheet
set objs = s.GetActiveSheetObjects.SheetObjects
end sub

[rwunderlich · Accepted solution]

You can't mix GetActiveSheetObjects and SheetObjects.

GetActiveSheetObjects returns an array of sheet objects.

SheetObjects(i) returns a single sheet object and requires a parameter, the index of the sheet object array.

-Rob

[#3]

Thanks for the clarification.

I got that code from the API Guide version 9.

The following replacement worked fine:

Objects = ActiveDocument.ActiveSheet.GetSheetObjects
For i = lBound(Objects) To uBound(Objects)
If Objects(i).GetObjectType = 10 Then 'pivot tables
set pivot = Objects(i)