To save as Excel CSV file:

Response.ContentType=”application/csv”
Response.AddHeader “Content-Disposition”, “filename=myfile.csv”

To save as any type:

Response.ContentType=”application/x-msdownload”
Response.AddHeader “Content-Disposition”, “filename=sitemap.xml”