How to open multiple text files?

**jp001** · 07-31-2009, 06:10 PM

I'd like to open all ".txt" files in a folder one by one to extract data into a worksheet - would someone have some code which does this or something similar please? Thanks in advance!

**JBeaucaire** · 07-31-2009, 08:50 PM

Here's a macro I've got that imports XLS files as separate sheets. If you use the macro recorder to record you opening ONE of your text files, you could probably mix that code with this to get a macro that does what you need.

Please Login or Register  to view this content.

**jp001** · 07-31-2009, 09:15 PM

Thanks for that - I've got something similar but remember seeing some code to loop through all the files in a folder until it reaches the end, which is what
I'm stuck on at the moment. The help file is no help on this one as far as I can see

**Leith Ross** · 07-31-2009, 09:24 PM

Hello jp001,

Do you mean to search all subfolders within the folder, and then all subfolders of the subfolders till there are no more?

**jp001** · 07-31-2009, 09:40 PM

Originally Posted by Leith Ross

Hello jp001,

Do you mean to search all subfolders within the folder, and then all subfolders of the subfolders till there are no more?

No, just all the .txt files in the one folder thanks.

**ravishankar** · 08-01-2009, 01:11 AM

Hi
The macro in this link
http://www.excelforum.com/excel-prog...ets-macro.html
opens each text file and imports to excel. Give it a try.
Ravi

**jp001** · 08-01-2009, 04:26 AM

Thanks Ravi, but this is what I was looking for, simple and elegant:

Please Login or Register  to view this content.

**JBeaucaire** · 08-01-2009, 11:32 AM

No one can be offended with a simple:

"This is what I was looking for. Thanks for your help anyway."

Your version...very easy to be put off by.

============
Anyway. if that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].