txt files import into excel

[ferverx]

Hello!



First of all I would like to thank all the people who helped me to start think "in excel"! Then comes the problem:
I have folder named FILES containing folders named A, B and C.
Each folder consists of many *.txt files named by format "yyyymmdd.txt".
I need Excel to import the data into sheet named by A, B and C (the name of folder) and if there's no such sheet then create.
Excel imports these data into sheet by date - starting from the first yyyymmdd till last (there is also error check preventing to import duplicate entries).
I have added 2 example txt files as attachment. In the sheet column one is date (1st column in txt file).


P.s.it would be nice also to enter a starting date in msgbx.

[Killian]

Hi there

So like the solution in your earlier thread but with a few changes?

[ferverx]

Hi there

So like the solution in your earlier thread but with a few changes?

Yes kinda, but here I have many folders and dont know how to make loop through all of them, and the files are now tab delimited, not koma seperated,
so I am asking for little help