Capture footer info without opening a workbook

[Guest]

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

 

[Jim Rech]

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
| 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