OWC component error

Rappa21 · #1 (**permalink**) 05-22-09, 12:34

I have this code:

Code:

Set oExcel = Server.CreateObject("OWC11.Spreadsheet")
Path=Server.MapPath("Ejercicio3.xls")
oExcel.Cells(1,1).Value = "Pete"
oExcel.Cells(1,2).Value = "John"
oExcel.Cells(1,3).Value = "Lana"
oExcel.ActiveSheet.Export Path, 0

And I get this error when executing the page:

Quote:

Microsoft VBScript runtime (0x800A01B6)
Object doesn't support this property or method: 'Export'

Any help and ideas will be greatly appreciated

Rappa21 · #2 (**permalink**) 05-22-09, 13:11

As dumbass as I am, I found what was going wrong. the line saying:

Code:

oExcel.ActiveSheet.Export Path, 0

Sould say:

Code:

oExcel.Export Path, 0

Internet Services

Web Development

Digital Marketing

Consumer Tech