Using

LEFT(CELL("filename",A1),FIND("]",CELL("filename",A1)))

in conjunction with the SUBSTITUTE command,

I can generate a txt string showing the path to a cell on an unopened work
book, but I don’t know how to use this sting to actually retrieve data from
that cell !?!?

Is there something like the value command I can use?

I really would appreciate any help in this matter ..

Thanks in advance Chris