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

    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")
    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

  2. #2
    Join Date
    Jul 2004

    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

Posting Permissions

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