C
Chris Oswald
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"><%=" " & CStr
(objField.Value)%></td>
<%
Else
%>
<td><%=objField.Value%></td>
<%
End If
Next
%>
</tr>
<%
objRS.MoveNext
WEnd
%>
</table>
<%
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"><%=" " & CStr
(objField.Value)%></td>
<%
Else
%>
<td><%=objField.Value%></td>
<%
End If
Next
%>
</tr>
<%
objRS.MoveNext
WEnd
%>
</table>
<%