![]() |
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"<%=" " & 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