Consulting

Results 1 to 3 of 3

Thread: Sleeper: Import of txt file generates error 1004

  1. #1

    Sleeper: Import of txt file generates error 1004

    ... during the the import of the txt file i recieve "error 1004"???????????????????

    Macro is in module2
    The file of txt is in the zip file (regione.02)

  2. #2
    VBAX Master TonyJollans's Avatar
    Joined
    May 2004
    Location
    Norfolk, England
    Posts
    2,291
    Location
    Because REGIONE_DISK!$A$2 is Empty ..

    FirstFree returns nothing, so n is empty, so ..

    Elenco.Range("A" + CStr(n)) resolves to Elenco.Range("A"), which is not a valid address
    Enjoy,
    Tony

    ---------------------------------------------------------------
    Give a man a fish and he'll eat for a day.
    Teach him how to fish and he'll sit in a boat and drink beer all day.

    I'm (slowly) building my own site: www.WordArticles.com

  3. #3
    OK! in Module2 is possible to make a control on a column A (there are UNIQUE ID) if for error the user reimport the same file?

Posting Permissions

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