Name a Excel Spreadsheet

Hello.

Is there a way i can add a name to an excel spreadsheet. I know I can send data to excel usuing this


Response.ContentType = "application/vnd.ms-excel"

Do you mean name the sheet or the file or something else?

yes, I mean the sheet.

Here is your answer:

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q288130

This is important for you:


'Rename Sheet1 to "Orders", rename Sheet2 to "Totals" and remove Sheet3
Set oOrdersSheet = oSS.Worksheets(1)
oOrdersSheet.Name = "Orders"
Set oTotalsSheet = oSS.Worksheets(2)
oTotalsSheet.Name = "Totals"
oSS.Worksheets(3).Delete