Importing numerous files
 

Thanks for the reply!!! Apologies - I should have been
more specific.

I am trying to import (append) all these text files from a
specified folder into an excel spreadsheet. So far, I've
only been able to append these comma delimited files by
repetitively going to the bottom of the spreadsheet,
clicking "get external data" and going thru the import
wizard. I've tried to write a macro to do this by
modifying a recorded macro but I'm not a VB programmer and
can't get it to work. (Is there a way to have VB tell you
where the code errors are?) Perhaps I'm on the wrong
track...

Any further help would be GREATLY appreciated!!!




-----Original Message-----
Hello,
If all you are trying to do is append numerous txt files,
I know a way.

Create a folder and put all your txt files in that folder.
Then, click start and select Run - type cmd and a "DOS"
prompt should appear. Change directories to the folder
you created and has all the txt files you are trying to
concatonate.
Then, type at the command prompt:
COPY * ALLFILES.TXT

where ALLFILES.TXT is the name of your output file.
Hope this helps! :-)
-----Original Message-----
Is there a way to import or append numerous (80) text
files into a spreadsheet without having to import one at
a
time?
.

.