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("E xcel.Applicatio n")
EWB = EApp.Workbooks. Add
ESh = EWB.Worksheets. Add
Add2Log("Creati ng Excel objects")
Catch ex As Exception
Response.Write( "<br><br>Er ror Creating Excel. Message:" &
ex.Message.ToSt ring)
Add2Log("Error: " & ex.Message.ToSt ring)
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