Coding tips I need to write down

Whatever helps

Excel MIME filename

When I want to control what the filename is in the 'Save As...' dialog box while downloading a MIME attachment from my ASP page.

Use the following line of code before the HTML tag has been written to the Response object:

Response.AddHeader "Content-disposition", "attachment; filename=Data.xls"

This line in conjuction with:

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

Will prompt Excel to open your content with the filename Data.xls in the 'Save As...' dialog box