ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   ASP Dynamic Excel Creation (https://www.excelbanter.com/excel-programming/316213-asp-dynamic-excel-creation.html)

Chris Oswald

ASP Dynamic Excel Creation
 
When I dynamically generate my Excel file it prompts me
twice to open it. Any ideas why?

Office 2003
Windows XP
IE 6

Response.ContentType = "application/vnd.ms-excel"
Response.AddHeader "Content-
Disposition", "attachment;filename=OSRHistory" &
strVersion & ".xls"

%
<table border="1"
<tr
<%
For Each objField In objRS.Fields
%
<th style="background-
color:gray;color:white"<%=objField.Name%</th
<%
Next
%

</tr

<%
While Not objRS.EOF
%
<tr
<%
For Each objField In
objRS.Fields

If (UCASE(objField.Name) = "STATION") Then

%
<td align="Center"<%="&nbsp;" & CStr
(objField.Value)%</td
<%
Else
%
<td<%=objField.Value%</td
<%
End If
Next
%
</tr
<%
objRS.MoveNext

WEnd
%
</table
<%


All times are GMT +1. The time now is 04:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com