Footer info from unopened workbook
 

Is it possible to extract footer information from an unopened workbook?

I have a macro in an otherwise empty workbook. It traverses folders,
capturing file name information from xls files. In some events, I'd like the
footer information from a known sheet name in a workbook rather than the file
name information.

Possible?

Thanks!