Combining text files in excel format

[vinwin06]

Hi,

I have 30 different files in the same path, but the name of the each file should be different, how i can combine all the files data into a single excel file.

If there is any macro will help me solve this.

Thanks in advance!!!

[arthurbr]

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.