Pull, can't get working
 

I need to do similar to the INDIRECT() function, to closed workbooks.
Obviously indirect doesn't work for this. The trouble being that the user of
the worksheet will always want to change the settings of the sheet, looking
at diffierent names, values etc. It is not practical to have all this
information stored on 1 sheet, so it is saved in different sheets, and a
number of workbooks.

Doing a search I found a similar problem from someone back in Feb and
followed the answer, I downloaded PULL() and put it in the VBA for the
workbook.

=pull("'S:\Close Assistance\"&Main Files&"\"&Field Managers&"\["&Field
Managers.xls&"]"&YYComp&"'!"&C65517) (C65517 contains "E25") returns #NAME?

Tried without all the "& stuff in the middle but to no avail.

Can anyone assist me with this matter? Also, why isn't there a built in
function in Excel that already does this?