"Corben" wrote in message
...
At my work, we have about 10 computers that save data to a text file on a
daily basis. The file names that are created at the same, so we have to
save
it to a different location on the network. Filenames are in date format
ex:
03-15-06.txt

I'd like to be able to put the information together, and have been doing
it
manually for a while now. Right now I open each file, copy the data, and
then
create a seperate single .txt file with all the data for each day. I then
open the file in Excel and use Tab, Semicolon, and Colon as delimiters.

Does anyone know if a macro can be set up to look into the seperate
folders,
and open each file, copying all the data into 1 worksheet?

If this can be done, or if anyone has any suggestions, I'd appreciate it.
Thanks,

I'm using Excel 2003


The answer is "yes".

Based on my own learning style, the best way to learn how is to record a
macro as you do the steps manually. But, don't use important files while
experimenting. Rename the text files first, and use a dummy Excel sheet, not
the one you need for business purposes. After recording the macro, open the
editor to inspect it, and with the help of a VBA book (from your local
library?), begin to understand how the macro performs each step.