Or you could name the sheet

[vba]

Set objApp = New Excel.Application
'This is new 'Your excel spreadsheet file goes here
Set objBook = objApp.Workbooks.Add(strTemplatePath)
'Name of sheet you want to export to
objBook.Worksheets(1).Name = "Detail"
Set objSheet = objBook.Worksheets("Detail")
objBook.Windows(1).Visible = True
'Opens the recordset and sets the variable
[/vba]