View Single Post
  #1   Report Post  
Mike D
 
Posts: n/a
Default 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