Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    18

    Question Unanswered: "Error 1004" Application-defined or object defined error

    I keep getting the run time error 1004, but the problem is that the error appears after a finished inserting data in excel (code line: if isnull(rrec!campo) then ...), so I don't know why.
    the programs runs well until that line, but the error is related with excel?

    Basically, the code is:
    Dim AppExcel as variant
    Set AppExcel = CreateObject("Excel.application")
    Set vXLS = AppExcel.Workbooks.Open(oIcallerForm.IniTemplateDi rectory & "\template5.xls")
    vXLS.Sheets("Hoja3").Select
    with vXLS
    (...)

    .Cells(pE, 9).Formula = Trim(rRec!expo_prod_nombre)
    .Cells(pE, 10).Formula = "3.- Pedido"
    slog = "mensaje" (executes ok!)

    if isnull(rrec!campo) then .... (Error 1004)

    Why should I do? Thanks
    Marce

  2. #2
    Join Date
    Jul 2004
    Posts
    1

    null error

    if you donot enter any data into the excel sheet this error normally comes.
    if you have any further quesitions regarding excel please contact me at ambreesh@gmail.com

Posting Permissions

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