PDA

View Full Version : Sleeper: Import of txt file generates error 1004



sal21
09-01-2004, 02:12 AM
... 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)

TonyJollans
09-01-2004, 02:53 AM
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

sal21
09-01-2004, 04:43 AM
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?