Get all objects of a specific Sheet

[ThomasGorr]

Hi all!

Is it possible to get all objects which are on a specific Sheet?

For example something like this:

var sheet = qv.getSheetByName("DATA");

var obj = sheet.getObject("LB01").Data.Rows[0][0];

Where "DATA" is the name of the Sheet and LB01 is a Listbox within this sheet.

Thanks for the answer,

Thomas.

[m_woolf]

This is from the API Giuide:

rem  ** remove borders from all listboxes on active sheet **

set x = ActiveDocument.ActiveSheet.GetSheetObjects

Objects = x.SheetObjects

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

      set obj = Objects(i)

      if obj.GetObjectType = 1 then          'list boxes

            set p = obj.GetProperties

            p.Layout.Frame.BorderEffect = 0  'no border

            obj.SetProperties p

      end if

next

[nagireddy_qv]

Hi,

Here is the API guide that might help you.