Linking and long pathnames

[Dennis Korinek]

I have several files linked but they come up with long pathnames...
such as the following...
=CONCATENATE(IF('C:\0data_d\DKsStuff\VAC\2004\Storage\[2004vacPA4899.xls]Allen,
Paul B'!D11<>"",'C:\0data_d\DKsStuff\VAC\2004\Storage\[2004vacPA4899.xls]Allen,
Paul B'!$D$1002&"("&'C:\0data_d\DKsStuff\VAC\2004\Storage\[2004vacPA4899.xls]Allen,
Paul B'!D11&") ",""))
I want to be able to use a function to replace the pathname with
something a lot simper... such as Name01. I have tried the Indirect
function but it requires the linked workbook to be open. I have tried
naming a cell with the long pathname in it but that doesn't work
either. Any help would be appreicated.

Dennis

 

[Harlan Grove]

I have several files linked but they come up with long pathnames...
such as the following...
=CONCATENATE(IF('C:\0data_d\DKsStuff\VAC\2004\Storage\[2004vacPA4899.xls]Allen,
Paul B'!D11<>"",'C:\0data_d\DKsStuff\VAC\2004\Storage\[2004vacPA4899.xls]Allen,
Paul B'!$D$1002&"("&'C:\0data_d\DKsStuff\VAC\2004\Storage\[2004vacPA4899.xls]Allen,
Paul B'!D11&") ",""))
I want to be able to use a function to replace the pathname with
something a lot simper... such as Name01. I have tried the Indirect
function but it requires the linked workbook to be open. I have tried
naming a cell with the long pathname in it but that doesn't work
either. Any help would be appreicated.

If you're usually working with closed files, see the last two alternatives in

http://www.google.com/[email protected]