Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
import few text files from subdirectories
Hello
Now I've got big problem :) I've directories like this: c:\backup\XXXX\Y where XXXX is the year e.g. c:\backup\2006\Y and Y is the month e.g c:\backup\2006\5 but c:\backup\2006\10 My text files which are in those directories are named hhmmssddmmyyyy.txt e.g 10123425082006.txt They look like this: 2006-08-25 13:33:20 82,8 g 2006-08-25 13:34:10 58,5 g between each column there is Tab My problem is that I would like ask the user from which month he would like to import text files to workbook.sheet2 (I've already done it by DateAdd) and then my macro should import all the text files in directory to one sheet one after another... I can't make it... Thx for any help!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import text files into EXCEL | Excel Discussion (Misc queries) | |||
Import multiple text files (Macro) | Excel Discussion (Misc queries) | |||
Import 2 text files into 2 separate columns? | Excel Discussion (Misc queries) | |||
Import of Multiple Text Files | Excel Programming | |||
How do I import several text files into excel or access ? | Excel Discussion (Misc queries) |