reference to closed workbook

[buckyduke]

the INDIRECT formula will not pull values from a closed workbook, wha
is a solution to this?

I am trying to reference a cell in a closed workbook on a sheet tha
has the same name as the active sheet, so I want to be able to us
MID(CELL("filename"),FIND("]",CELL("filename"))+1,255) in the referenc
to the other workbook...

thank

 

[Kevin H. Stecyk]

"buckyduke >wrote...

INDIRECT formula will not pull values from a closed workbook, what
is a solution to this?

I am trying to reference a cell in a closed workbook on a sheet that
has the same name as the active sheet, so I want to be able to use
MID(CELL("filename"),FIND("]",CELL("filename"))+1,255) in the reference
to the other workbook...

thanks

As posted by Harlan Grove, http://tinyurl.com/2y3hw

******

If you want to avoid using macros and use formulas instead, your *only*
options
are to download and install Laurent Longre's MOREFUNC.XLL add-in, available
at

http://longre.free.fr/downloads/Morefunc.exe

(which is an installer for the add-in). It's INDIRECT.EXT works with most
versions of Excel (e.g., my laptop running Excel 97 SR-2 under NT 4 SP-6)
but
not all (e.g., my wife's PC running Excel 2000 SR-3 under Windows Me).

The other option involves running two instances of the Excel application
object,
with the second under the control of the first. UDFs in the first would
enter
hard-coded external link formulas into worksheet cells in the second and
return
the results to their caller. VERY CRUDE compared to MOREFUNC.XLL.*****Good
luck.

Best regards,
Kevin

 

[Harlan Grove]

the INDIRECT formula will not pull values from a closed workbook, what
is a solution to this?

....

Multiposted to .worksheet.functions, and answered there. Your chosen means
of posting to and reading from Excel newsgroups is less than ideal. If
excelforum provides no means to *crosspost* as opposed to multiposting, then
post to *ONE* AND ONLY *ONE* newsgroup. It's possible excelforum doesn't
provide these usage instructions, but multiposting is *ALWAYS* bad!