I can reproduce it with the followoing aspx file. It works fine for me under
2003, but just hangs in 2000 server.
<script language="VB" runat="server">
Sub Page_Load(Sender as Object, E as EventArgs)
Dim EApp As Object, EWB As Object, ESh As Object
Dim rowcount
Try
EApp = CreateObject("Excel.Application")
EWB = EApp.Workbooks.Add
ESh = EWB.Worksheets.Add
rowcount = 1
ESh.Cells(rowcount, 2).value = "Total"
lblMsg.Text = Esh.Cells(rowcount, 2).Value
Catch ex As Exception
Response.Write("<br><br>Error Creating Excel. Message:" &
ex.Message.ToString)
Exit Sub
Finally
EWB.Close()
Esh = Nothing
EWB = Nothing
EApp = Nothing
End Try
End Sub
</script>
<html>
<head><title>My First ASP.NET Page</title></head>
<body>
<form action="myaspnet.aspx" method="post" runat="server">
<h1><asp:label id="lblMsg" runat="server"/></h1>
<p>
</p>
</form>
</body>
</html>
"David Reynolds" wrote:
Hi Everybody,
I have a vb.net webform where I create the Excel
application/workbook/worksheet. On Windows 2000 server for some reason, I
keep getting an error("Bad variable type") when trying to first set the value
to a cell. I don't have the problem on 2003 server or XP, and I'm wondering
if anyone knows of a get around on 2000?
Try
EApp = CreateObject("Excel.Application")
EWB = EApp.Workbooks.Add
ESh = EWB.Worksheets.Add
Add2Log("Creating Excel objects")
Catch ex As Exception
Response.Write("<br><br>Error Creating Excel. Message:" &
ex.Message.ToString)
Add2Log("Error: " & ex.Message.ToString)
Exit Sub
End Try
......
ESh.Cells(1, 2).value = "Total"
The error message has been puzzling me and I can't seem to see why it would
return that error. It does seem to be creating the Excel objects okay