vb.net webform on 2000 returns "Bad variable type" for Excel

Guest · Feb 2, 2005

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

Guest · Feb 2, 2005

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>

Guest · Mar 24, 2005

David,

I'm having exactly the same problem, only I'm trying to access the content
of a cell. Did you ever come up with a resolution?

Thanks,
Paul

"Bad Variable Type", Excel, W2K	5	Jul 28, 2003
Upload Excel Spreadsheet	2	Feb 12, 2009
Got error CS0433 for Crystal Report on Windows 2000 Server	3	Aug 1, 2006
Cannot create ActiveX component	3	Mar 14, 2007
Closing Excel on server	0	Sep 5, 2005
Excel 2007 Charts with PyWin32	1	Oct 14, 2008
Trouble using WIN32OLE for excel	1	Oct 15, 2007
SQL Database to MS Excel sheet.	1	Apr 5, 2008

vb.net webform on 2000 returns "Bad variable type" for Excel

Guest

Guest

Guest

Ask a Question

Similar Threads

Members online

Forum statistics

Latest Threads