Import Multiple Text Files into Excel - for beginners

rapidasia

New member
Joined
Aug 20, 2012
Messages
1
Reaction score
0
Points
0
I need some hand holding please. Zero experiences with VBA - step by step appreciated by me and the hordes of newbies...
I need to import multiple text files into an Excel spreadsheet.
the files are simple text, single line, single column no parsing needed.
I want to import multiple files into a column in a worksheet
folder = /filefolder/
files = textfile-01.txt
textfile-02.txt through textfile-250.txt

I want textfile-01.txt to be in C1
I want textfile-02.txt to be in C2 etc.

I got as far as ALT+F11 opens VBA editor....
thanks in advance
 
Top