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

It seems to me that, unless you have the XLS file format (something MS has
not published since Excel 97) and can read the unopened file as a stream of
bytes to find what you want, you'll have to open the file to get the page
footer.

--
Jim Rech
Excel MVP
"microfich" wrote in message
...
| 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