solution to reference closed workbook

B

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
 
T

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
 
Top