VBA-wise, Is it possible to capture footer information from a sheet within a
workbook without opening the workbook?

I have a macro in an otherwise empty workbook. It loops through hundred of
xls files, capturing file name information. In some events, I would like the
footer information from a known sheetname within a workbook rather than the
file name. With so many files, opening would take too much time.

Thanks!

Using: MS Excel 2002 with Windows XP Professional