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

--
Message posted from http://www.ExcelForum.com

There was a topic about getting data from a closed workbook aroun
friday last week and there was a link there for a code to do that bu
sorry I can't remember it so I think a search should do it.

But why not open the workbook, get the stuff you want and close it?
do it all the time (Although I am a newbie in VBA) and I see no harm i
it.

Best Regards

Noo

--
Message posted from http://www.ExcelForum.com