ChangeWorksheet Method

The ChangeWorksheet method changes the worksheet path, filename, or sheet for a single worksheet reference for all plots in which it is used.

Syntax

object.ChangeWorksheet( oldWksFilename, newWksFilename )

Parameter	Type	Description
oldWksFilename	Variant	required, full path to current worksheet reference
newWksFilename	Variant	required, full path to new worksheet reference

Example

The following example demonstrates changing the path for a worksheet reference to a new one.

Document.ChangeWorksheet( _

   oldWksFilename:="C:\Program Files\Golden Software\Grapher\Samples\3d bar chart.dat", _

    newWksFilename:="C:\Temp\my data file.csv")

 

Used by: Document object