Is there any way I can ‘calculate’ external references?
=’n:path1path2path3Excel[Text Function2.xls]Sheet1′!$D$11
Will work if.
What I would like to do is allow the user to type/select the path and file name so that I can then calculate the reference like so:
=Path&FileName&Sheet&”!$D$11″
i.e. I know where in the spreadsheet I want to get information from, I would just like to allow the user to select the worksheet they want to get the data from. The cell co-ordinates/range name will not change. Just the workbook name/location.
Can this be done without resorting to VBA?
Regards
Peter