Results 1 to 2 of 2
  1. #1
    Join Date
    May 2009
    Posts
    4

    Question Unanswered: OWC component error

    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:
    Microsoft VBScript runtime (0x800A01B6)
    Object doesn't support this property or method: 'Export'

    Any help and ideas will be greatly appreciated

  2. #2
    Join Date
    May 2009
    Posts
    4
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •