In my WB1.xls I have:
In Cell A6 '0514121-A
In cell B6 ="[PA"&A6&"-JM.xls]PaySchedule"
In Cell Z1 'C:\Documents and Settings\Contracts\

In Cell G6 << I need to link to Cell D10 (with a dollor Value in

Z1 & B6 ' or 'C:\Documents and
Settings\Contracts\="[PA"&A6&"-JM.xls]PaySchedule"

PA0514121-A-JM.xls will remain Closed throughout.

Any help would be appreciated

Jim,

Take a look at Morefunc at Laurent Longre's site,
http://xcell05.free.fr/english/, it has a function called INDIRECT.EXT that
should do what you want.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Jim May" <(E-Mail Removed)> wrote in message
news:472AAA21-5847-4460-BF8E-(E-Mail Removed)...
> In my WB1.xls I have:
> In Cell A6 '0514121-A
> In cell B6 ="[PA"&A6&"-JM.xls]PaySchedule"
> In Cell Z1 'C:\Documents and Settings\Contracts\
>
> In Cell G6 << I need to link to Cell D10 (with a dollor Value in
>
> Z1 & B6 ' or 'C:\Documents and
> Settings\Contracts\="[PA"&A6&"-JM.xls]PaySchedule"
>
> PA0514121-A-JM.xls will remain Closed throughout.
>
> Any help would be appreciated
>