topic How to Access User Created Table Box via Automation Interface? in QlikView

How to Access User Created Table Box via Automation Interface?

Mon, 06 Apr 2015 16:29:45 GMT

Hi Folks:

We are attempting to access a user created table box via the automation interface with statements like this:

Set obj1 = newdoc.GetSheetObject("TB458-43")

obj1.SendToExcel

Unfortunately, the object is set to nothing but all other parts of the code work fine.

It seems user created objects like this table box (TB458-43) are not accessible via the automation interface?

What changes do me need to make to make this possible?

Many thanks.

petter — Mon, 06 Apr 2015 22:30:12 GMT

You will have to do someting like this:

Set obj1 = newdoc.GetSheetObject("Server\TB458-43")

Unless you prefix your sheetobject with Server\ you will not find anything... (I think it is case-sensitive)

I use "User Created Objects" on a QlikView document on a QlikView server from C# without a hitch... but I used

the GetTablesBoxes method to get a list of tableboxes. So then I was able to inspect what the ObjectID was of

the retrieved objects.

Tue, 07 Apr 2015 01:11:37 GMT

Thanks Petter!

Works perfectly.

petter — Tue, 07 Apr 2015 06:56:59 GMT

Glad I could help. Could you please mark the suggestion as answered so the thread will be closed and verified as solved