help with linking

[Jim May]

In Wookbook WB1.xls cell G6 I have:
='[PA0514121-A-JM.xls]PaySchedule'!$D$11

PA0514121-A-JM.xls is and will remain CLOSED.

In Cell A6 of WB1.xls I have the text 0514121-A

How can I modify G6 above to read the content of Cell A6?

Here's my latest attempt.. resulting in #REF!

='[&"PA"&A6&"-JM.xls"]PaySchedule'!$D$11

Thanks in advance for any assistance,

 

[Biff]

Hi!

You'd have to use Indirect but it won't work on a closed file.

Alternatives:

Harlan Grove's PULL utility. You can find it with a Google search.

Laurent Longre's MOREFUNC add-in. Look for INDIRECT.EXT.

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

Biff

 

[Jim May]

Great, Got the Pull(xRef As String)As Variant
Downloaded and installed in a Standard Module of my Workbook..
But don't know how to apply to my scenario,
Can you assist?
TIA,
Jim

Hi!

You'd have to use Indirect but it won't work on a closed file.

Alternatives:

Harlan Grove's PULL utility. You can find it with a Google search.

Laurent Longre's MOREFUNC add-in. Look for INDIRECT.EXT.

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

Biff

In Wookbook WB1.xls cell G6 I have:
='[PA0514121-A-JM.xls]PaySchedule'!$D$11

PA0514121-A-JM.xls is and will remain CLOSED.

In Cell A6 of WB1.xls I have the text 0514121-A

How can I modify G6 above to read the content of Cell A6?

Here's my latest attempt.. resulting in #REF!

='[&"PA"&A6&"-JM.xls"]PaySchedule'!$D$11

Thanks in advance for any assistance,

 

[Biff]

Can you assist?

Sorry, I've never tried it!

Maybe post a "Ping" for Harlan.

Biff

Great, Got the Pull(xRef As String)As Variant
Downloaded and installed in a Standard Module of my Workbook..
But don't know how to apply to my scenario,
Can you assist?
TIA,
Jim

Hi!

You'd have to use Indirect but it won't work on a closed file.

Alternatives:

Harlan Grove's PULL utility. You can find it with a Google search.

Laurent Longre's MOREFUNC add-in. Look for INDIRECT.EXT.

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

Biff

In Wookbook WB1.xls cell G6 I have:
='[PA0514121-A-JM.xls]PaySchedule'!$D$11

PA0514121-A-JM.xls is and will remain CLOSED.

In Cell A6 of WB1.xls I have the text 0514121-A

How can I modify G6 above to read the content of Cell A6?

Here's my latest attempt.. resulting in #REF!

='[&"PA"&A6&"-JM.xls"]PaySchedule'!$D$11

Thanks in advance for any assistance,