Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Rubemarin ... You're the Man!!!