'Multisheet XLS.bas shows how to specify a particular sheet in
'an Excel XLS or XLSX file to use for gridding.

'=====================================

Sub Main

	Dim SurferApp As Object
	Set SurferApp = CreateObject("Surfer.Application")
	SurferApp.Visible = True

	Dim Plot As Object
	Set Plot = SurferApp.Documents.Add(srfDocPlot)

'Use GridData2 to grid data and specify data file options, such as XLS sheet name
	SurferApp.GridData2("c:\temp\Book1.xlsx", DataFileOptions:="sheet=Test", ShowReport:=False, OutGrid:="c:\temp\test.grd")

'Create a contour map from the grid file
	Plot.Shapes.AddContourMap(GridFileName:="c:\temp\test.grd")

'Use AddPostMap2 to create a post map from a data file and specify data file options, such as XLS sheet name
	Plot.Shapes.AddPostMap2("c:\temp\Book1.xlsx", DataFileOptions:="sheet=Test")

	Plot.Shapes.SelectAll
	Plot.Selection.OverlayMaps

End Sub