asp to excel

[Mike D]

I am using asp to create an excel file on the fly using:
Response.ContentType="application/x-msdownload"
Response.AddHeader "Content-Disposition", "attachment; filename=" &
strRunIDName & ".xls;"

This opens the file download dialogue box. When I click open it opens
another identical dialogue box where I have to click open again. How do I
open with only one click. Is this an IE thing or something in the asp code?

Mike

 

[PR]

Try this as your very first line on the asp page:

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

I use ASP to create a large table of data. I then include that line at the
very top of the asp page. IE recognizes it and opens the page in excel
(within a browser). From what I understand, as long as you're creating an
html table, excel will handle it nicely.