Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
manudenegri
Contributor III
Contributor III

How to set ObjectID on TextObject

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

M

Labels (2)
1 Solution

Accepted Solutions
rubenmarin
MVP
MVP

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

View solution in original post

2 Replies
rubenmarin
MVP
MVP

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
Contributor III
Contributor III
Author

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