Hi X82,

Having a macro open and read all the files isn't especially difficult, nor is captuing their names in an Excel workbook.

However, extracting the correct data from four different formats is problematic. To be able to do that, the files would need to contain something that is unique to each format so the code can differentiate one from the other. For example:
File1 contains the string 'IMax IMin'
File2 contains the string 'Switched Rack PDU'
File3 contains the string 'Pwr.kW'
File4 contains the string 'I Ph1 I Ph2 I Ph3',
which none of the others contain. If those strings are always present in those formats only, they could be used for differentiation purposes.

Further, while all these data can be imported into Excel, it seems to me that you're capturing different fields, so I'm not sure you'll be able to make much use of it if it all goes onto the same worksheet. It might be better if the data for each format were written to different worksheets.

If you can clarify the above issues, we can make some progress.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]