| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Importing mulitple .txt files to excel
Hi
I have up to 100 .txt file in a folder each containing one line of text in a pipe delimited format. Each line of text contains the same number of data items and once delimited to Excel contains the same data type in each column. I would like to iterate throught each file in the folder and be able to import each line of text to the same sheet in Excel each line being imported to its own row. Can anyone give me a clue as how I would go about this using VBA. Thanks all... Mike |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Importing mulitple .txt files to excel
There is a utility called TxtCollector which will append all those text
files into one, then you can import one big text file: http://bluefive.pair.com/txtcollector.htm MH "mikerobe" wrote in message oups.com... Hi I have up to 100 .txt file in a folder each containing one line of text in a pipe delimited format. Each line of text contains the same number of data items and once delimited to Excel contains the same data type in each column. I would like to iterate throught each file in the folder and be able to import each line of text to the same sheet in Excel each line being imported to its own row. Can anyone give me a clue as how I would go about this using VBA. Thanks all... Mike |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Importing mulitple .txt files to excel
On 18 Mar, 22:11, "MH" wrote:
There is a utility called TxtCollector which will append all those textfilesinto one, then you can import one big text file: http://bluefive.pair.com/txtcollector.htm MH "mikerobe" wrote in message oups.com... Hi I have up to 100 .txtfile in a folder each containing one line of text in a pipe delimited format. Each line of text contains the same number of data items and once delimited toExcelcontains the same data type in each column. I would like to iterate throught each file in the folder and be able to import each line of text to the same sheet inExceleach line being imported to its own row. Can anyone give me a clue as how I would go about this using VBA. Thanks all... Mike Thanks for the ultra quick response, great app and doing the job perfectly |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Importing mulitple .txt files to excel
"mikerobe" wrote in message
oups.com... Thanks for the ultra quick response, great app and doing the job perfectly That app has saved me so much time over the past year. Glad you like it. MH |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I append multiple sheets from mulitple xls. files. into 1 | Excel Discussion (Misc queries) | |||
| importing data from mulitple files in a directory | Excel Discussion (Misc queries) | |||
| Macro to create mulitple files | Excel Discussion (Misc queries) | |||
| Running a macro on mulitple files | Excel Programming | |||
| importing mulitple files | Excel Programming | |||
Hybrid Mode
