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