link to workbook by cell refrence

[Rich]

hiyais their a way to create a formula theat will look at a cell in another
workbook where the file the form is stored in may alter

what want to do is have a cell with a value in , and the formula then link
to a sheet thats stored in said folder

I.e =c:\>call b4\workbookname\page\cell

then file names within each folder are consistant its jut the FOLDER name
link am looking to locate via cell lookup

thanks

 

[David Biddulph]

The function you need is INDIRECT.