PDA

View Full Version : txt files import into excel



ferverx
12-15-2005, 08:38 AM
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
12-15-2005, 08:50 AM
Hi there :hi:

So like the solution in your earlier thread (http://www.vbaexpress.com/forum/showthread.php?t=6037) but with a few changes?

ferverx
12-15-2005, 09:15 AM
Hi there :hi:

So like the solution in your earlier thread (http://www.vbaexpress.com/forum/showthread.php?t=6037) 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: pray2: