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