I'm trying to create VBA code that will import a varying number of
text files into Excel 2000. The files will not have a .txt extension
but rather a varying numeric extension (.1, .2, .3 and so forth.
Using the macro recorder I have set up several macros that import the
text (only one file) and format it the way I want then cut and past it
into a worksheet. What I want to know how to do is import every file
in a folder, one at a time, and add the text to different rows of the
same worksheet. I have very little programming experience. Any help
will be appreciated. :)