Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
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 (1)
1 Solution

Accepted Solutions
rubenmarin

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

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!!!