Would you like to...

Print this page

Email this page

Post a comment

User Opinions

No users have voted.

---

How would you rate this answer?

Helpful

Not helpful

Thank you for rating this answer.

When loading a template from a script, only one worksheet can be named in the Open command. After the template is opened, each curve can be selected and the worksheet used can be changed. This example shows how to load the template with one worksheet and change the worksheet for one curve. The first curve ("Line/Symbol Plot 1") will still use the worksheet named in the Open command line.

'Opens Template
Set Plot = GrapherApp.Documents.Open (c:.grt", "c:.dat")
'Change worksheet of curve 2
Dim Graph1, Line2 As Object
Set Graph1 = Plot.Shapes.Item("Graph 1")
Set Line2 = Graph1.Plots.Item("Line/Symbol Plot 2")
Line2.worksheet = ("c:.dat")