topic How to set ObjectID on TextObject in QlikView

How to set ObjectID on TextObject

manudenegri — Mon, 26 Jan 2026 18:19:17 GMT

Hi I would like to set a TextObjet on a Macro

I use this:

Set myChart = ActiveDocument.Sheets("Diapo " & oSH.Cells(j,1)).CreateTextObject()
Set g = myChart

Set p = g.GetProperties

p.Frame.ObjectId = "jun "
g.SetProperties p

But it doesn't work .... Can you help me?

Regards

rubenmarin — Wed, 18 Mar 2020 16:39:18 GMT

Hi, if oSH.Cells(j,1) works as you expected probably the issue is that Frame is a property inside Layout, so:

p.Layout.Frame.ObjectId = "jun "

You can try first with a fixed name fro Sheets, if it works add the dynamic part of oSH.Cells

Regards

manudenegri — Thu, 19 Mar 2020 09:36:52 GMT

Rubemarin ... You're the Man!!!