salve a tutti. Vorrei creare un file Excel con n fogli, ho provato con questa funzione:

Dim FileName As String
FileName = "test.xsl"
Response.Buffer = True
Response.ContentType = "application/vnd.ms-excel"

Response.AddHeader("content-disposition", "inline; ")
FileName = " & FileName "
Response.Write("<Worksheet ss:Name=""Sheet1"">")

Response.Write("<table>")
Response.Write("<tr>")
For i = 1 To 15 Step 3
Response.Write("<td>")
Response.Write(i * i)
Response.Write("</td>")
Next
Response.Write("<td width=40><b>=somma(A1:D1)</b></td>")
Response.Write("</tr>")
Response.Write("</table>")
Response.Write("</Worksheet>")
Response.Write("<Worksheet ss:Name=""Sheet2"">")

Response.Write("<table>")
Response.Write("<tr>")
For i = 1 To 15 Step 3
Response.Write("<td>")
Response.Write(i * i)
Response.Write("</td>")
Next
Response.Write("<td width=40><b>=somma(A1:D1)</b></td>")
Response.Write("</tr>")
Response.Write("</table>")
Response.Write("</Worksheet>")
Response.Flush()
Response.End()

Ma non funziona, cioè mi crea il file ma con solo un foglio che chiama come il file. Cosa sbaglio? Grazie,
Silvia