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.
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.