Set Object ID using Macro

[kaushiknsolanki]

HI everyone,

I have written following macro for creating new chart

sub Create_Chart

set Graph = ActiveDocument.Sheets("Main").CreateLineChart
Graph.AddDimension "OrderDate"
Graph.AddExpression "sum({BM1}Total)"

end sub

But i dont know how can i set or change the object id of this chart...

If anyone can help me, that will be a valuable help to me..

Thanks in advance..

[#2 · Accepted solution]

Hi,

Add the following to your macro, it should do the trick

Dim gProps

gProps = Graph.GetProperties

gProps.GraphLayout.Frame.ObjectID = "NewChart"

Graph.SetProperties gProps

Thanks

Nick

[kaushiknsolanki]

Hi NIck,

Thanks for your valuable help..

It worked for me..

Hey NICK i want to ask you one more thing is API guide is available in PDF format... ?

If yes pls let me know the Download link..

Thanks

[#4]

Hi,

As far as I am aware there is no PDF version of the API Guide. There is a pdf reference that is installed with the SDK but it is not as in depth.

Thanks

Nick

[kaushiknsolanki]

Thanks NIck for your valuable time and support..