Import Multiple Text Files into Excel - beginner advice
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
Help Regarding Same issue
This VBA code was really helpful. Thank you so much for the guidance. I have a bit different scenario. I need to import 1500 files into one excel worksheet and each text file. The text files are in folder that is name of the language (e.g en for English). Now what i intent to do is to appear my text in one column under heading language name(that's folder name) and language text. my text file has either one sentence or either a paragraph. I don't want it to be in different columns. I tried this piece of code but text appears scattered.
P.S I am totally a newbie at VBA. Any help will be appreciated plz. how can i attach the file that i am using here in thisforum ?