Hi

How can I extract a value from a closed workbook?

I've tried with the 'Indirect' function but have since learnt that this
doesn't work when the wookbook is closed

i need something like

A1="C:\folder\<filename

TIA