importing multiple text files into the same worksheet
Hello,
I would like to run a macro which will firstly open a file selection box
(like the one that appears afte [file], [open]), let me choose a number of
files, then each one would be appended to the same worksheet.
The files are text and delimited by a space.
The standard import wizards does well, but there are tons of files I need to
import.
Any help would be much appreciated.
Regards,
Mike
|