topic Object required: 's.GetActiveSheetObjects' in QlikView

Object required: 's.GetActiveSheetObjects'

Tue, 20 Jul 2010 02:49:47 GMT

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

Object required: 's.GetActiveSheetObjects'

rwunderlich — Tue, 20 Jul 2010 06:16:51 GMT

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

Object required: 's.GetActiveSheetObjects'

Tue, 20 Jul 2010 23:57:12 GMT

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)