I'd like to convert text to be path & workbook name of the file from which I want to pull in the data.
How I can do it?
Example:
Text 'C:\MyDoc\[Trash.xls]Book1'!$A$1 to be reference for file Trash.xls.

Many thanks!
Yulia