solution to reference 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

 

[Tom Ogilvy]

Basically the answer is you can't do it with any direct function/builtin
function

I believe Harlan Grove wrote a User Defined function (UDF) in VBA that opens
another instance of excel, opens the file, extracts the information, closes
the file, closes the instance of Excel and returns the value to the cell.


In the below he provides that as well as to links on other approaches. (some
for open workbooks).

http://groups.google.com/[email protected]&output=gplain

 

[Harlan Grove]

...
...

In the below he provides that as well as to links on other approaches. (some
for open workbooks).

http://groups.google.com/[email protected]

...

The following link is more recent and more comprehensive.

http://www.google.com/[email protected]