Extracting footer informatiojn from unopened XLS file.

[Guest]

I'm trying to extract footer information from anunopened xls file.

I go through a loop of xls files to capture FILENAME information. No
problem there. But in some cases, I'd like to get the information from the
footer of a known sheet name instead. All this without opening the (big)
files, which takes too much time.

I've tried GetValue but can't get beyond the cell reference it returns to
get to the footer info.

Help please!?

Thanks!

 

[NickHK]

microfich,
If you really do not want to use automation, there is the older format:
Dim RetVal
RetVal = ExecuteExcel4Macro("GET.DOCUMENT(54)")

MS have have:
http://download.microsoft.com/download/excel97win/utility4/1/win98/en-us/mac
rofun.exe

and also
http://www.xl-logic.com/xl_files/formulas/xlm_functions.zip

NickHK