See this:

http://groups.google.com/group/micro...443753560f0075

--
Biff
Microsoft Excel MVP


"simplymidori" wrote in message
...

Hello,

How do use listed pathname to link values from another workbook?

ie

Column A Column B

C:\Downloads\Book1 ="A1 (PATHNAME)" TO GET VALUE IN Sheet1'!$D$8

Thanks in advance.