File Type Names

S

sam1

Hi,

Would anyone have any idea how i could find out which file type a
excel file has been saved in another file folder.

Eg File 123 in directory X, saved as Microsoft Excel 4.0 Worksheet,
would like this detailed in a separate spreadsheet eg:

File Name File Type
File 123 Microsoft Excel 4.0 Worksheet

This would be used for files in multiple locations?

Any ideas? can get for a file that is an active workbook but not fo
files in separate locations
 
Top