Confused by Linking

[Jim May]

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

 

[Harlan Grove]

Jim May wrote...

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.

You may have noticed this newsgroup gets limited traffic. You'd be
better off using

microsoft.public.excel.worksheet.functions

note the 4th period in the name. If you don't have access to that ng,
try these others.

microsoft.public.excel
microsoft.public.excel.misc

For your particular problem, the easiest approach involves using an
add-in, specifically, Laurent Longre's MOREFUNC.XLL, which is available
from

http://xcell05.free.fr/english/

Once installed, it provides an add-in function named INDIRECT.EXT which
would allow you to refer to this as

INDIRECT.EXT($Z$1&$B$6&"'!D10")