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