How to Access User Created Table Box via Automation Interface?

[#1]

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 · Accepted solution]

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.

[#3]

Thanks Petter!

Works perfectly.

[petter]

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