topic GetSheetObjects throws error in QlikView

GetSheetObjects throws error

krishnaroopa — Wed, 27 Jun 2012 07:23:30 GMT

We are using QV Version 10.

I am trying to get all charts in a sheet, inside a macro.

set Objects = ActiveDocument.getSheet(0).GetSheetObjects

ActiveDocument.ActiveSheet.GetSheetObjects

Both is not working.. I am getting an error - "Object Required"

Please help

regards

KRS

Re: GetSheetObjects throws error

Siva_Sankar — Wed, 27 Jun 2012 07:37:03 GMT

You can get the info you want by utilizing GetSheetObjects and GetObjectType (see the API Guide for more detail). Here is an example that will display each chart Id in a message box: Sub GetCharts Objects = ActiveDocument.ActiveSheet.GetSheetObjects For i = lBound(Objects) To uBound(Objects) If obj.GetObjectType = 11 'Charts Then msgbox("Chart: " & obj.GetObjectId) End If next End Sub Once you have the object Id of the chart, you will use GetProperties. Then you can manipulate the properties and use SetProperties. Regards. siva sankar