Hi,
I have an external data query and am trying to create a formula that returns
the name of the file from which the query data is taken. This is of course
straightforward using VBA but is there a non VBA mathod of retrieving the
name? Excel 2007 creates a named range with the same name as the original
file name for the external data query but I cannot find anyway of accessing
this inofrmation in a formula...
Many thanks for any suggestions.
Best wishes, Boris.