Help required in importing multiple .txt files into one excel sheet

[kar.chiranjib]

Hi all,

I'm trying to import multiple text files into one worksheet and have the following code.

It runs fine for the 1st file but throws error while refreshing the second one. The line where I'm getting the error is in bold. I'm getting the following error message "Run-time error '1004': Application-defined or object-defined error". Really appreciate all your help.

Please Login or Register  to view this content.

[kar.chiranjib]

Hi all,

I was able to find out the issue and it was due to incorrect file path. the code works perfectly now

[exc4libur]

Kar, hello. When you import, do you use the same array for all files? How could I change this code so that I can import multiple txt files with different arrays? Rgds