asp to excel

[Mike D]

I am using asp to create an excel file on the fly using:
Response.Conten tType="applicat ion/x-msdownload"
Response.AddHea der "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]

RE: asp to excel

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

Response.Conten tType = "applicatio n/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.

"Mike D" wrote:
[color=blue]
> I am using asp to create an excel file on the fly using:
> Response.Conten tType="applicat ion/x-msdownload"
> Response.AddHea der "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[/color]