Error in Code - Error Handler

[joogibabu]

Hi everyone

I have found a code from this forum to import text file, modified it to my need, but stuck on error handling . On error it still adds new sheet , and on No Error it still shows error handler message

Can any one correct it for me

following is the code

Please Login or Register  to view this content.

[Jockney]

At the end of your code put this

Please Login or Register  to view this content.

That will fix one of your problems.

In regards to the sheet being added it would depend where the error occurs. May I suggest you run this by tapping the F8 key. This will allow you to progress through the code line by line and will raise any issues and show you where it's occuring. Let me know if you need any more help

[joogibabu]

Many thankx . for error handler , it worked

It adds new sheet, when i try to import same file for second time after this code

Please Login or Register  to view this content.

[Jockney]

Please Login or Register  to view this content.

Give this a go instead of

Please Login or Register  to view this content.

[joogibabu]

;-(

On importing same file for second time, it generates error, clears it, add new sheet and import the file

[Jockney]

Are you running this code each time you want to import a file? can you explain exactly what the outcome you're after with this bit please. If you wanted to import the same thing twice then maybe just copying the tab would be better?