S
syd1138
I'm trying to export data from a large number of text files (1000+) into a
single excel worksheet.
The filenames are all named using the format:
filename-datestamp-timestamp.txt
and the data within the files are formatted:
<IP_Address><space><Code>
Ideally I'd like the workbook to take the format:
<Filename>,<IP_Address>,<Code>
Any help would be GREATLY appreciated,
Many thanks
single excel worksheet.
The filenames are all named using the format:
filename-datestamp-timestamp.txt
and the data within the files are formatted:
<IP_Address><space><Code>
Ideally I'd like the workbook to take the format:
<Filename>,<IP_Address>,<Code>
Any help would be GREATLY appreciated,
Many thanks