Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 <% |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Dynamic creation, or something different needed? | Excel Worksheet Functions | |||
Dynamic Formula Creation?? | Excel Discussion (Misc queries) | |||
Dynamic Creation of rows in Excel | Excel Programming | |||
Dynamic Control Creation in VBA | Excel Programming | |||
Dynamic Creation of borders | Excel Programming |