Hello,
I need to write/record a macro that takes multiple files(UNIX files)on
the local computer and then copy all their content back to a sheet of
the excel and then manipulate the data to generate a report. I
particularly need help with macros that can import multiple files. I
have come across an excel application whose button can prompt a windows
and import ONE file to do similiar thing. However, what I want to do is
more sophisticated. Do you have any idea?? do you have any resources
from the web?? Thx!!
Martin Fishlock - 20 Jan 2006 08:45 GMT
Why not make a list of the files to import and then work through the list
importing the processing the file as required.

Signature
HTHs Martin
> Hello,
>
[quoted text clipped - 6 lines]
> more sophisticated. Do you have any idea?? do you have any resources
> from the web?? Thx!!
Raven - 20 Jan 2006 08:56 GMT
oh, because the files are logs from several servers whose names change
daily.
and thx NickHK