Hi NG,

I try the following

J10 = contans a literal which is
1. a Productnumber XXXXXX
2. the name of a table that contains parts, concerned to the product.

in N10
=ADRESS(10;1;1;TRUE;"\\Server\Path\["&J10&".xls]Titelseite")
gives me the completed adress as text
'\\Server\Path\[XXXXXX.xls]Titelseite'!$A$10

Now i'm looking for a function to retrieve the value of that specific cell

I try in N11
=INDIRECT(N10)

but i get an error back
#REFERENCE (German #BEZUG)

I believe it should work but I can't see why it doesn't

thx in advance

--
Martin

You cannot use INDIRECT on a closed workbook. For this try this alternative
http://makeashorterlink.com/?F2993260A

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Martin Hallerbach" wrote in
message ...

Hi NG,

I try the following

J10 = contans a literal which is
1. a Productnumber XXXXXX
2. the name of a table that contains parts, concerned to the product.

in N10
=ADRESS(10;1;1;TRUE;"\\Server\Path\["&J10&".xls]Titelseite")
gives me the completed adress as text
'\\Server\Path\[XXXXXX.xls]Titelseite'!$A$10

Now i'm looking for a function to retrieve the value of that specific cell

I try in N11
=INDIRECT(N10)

but i get an error back
#REFERENCE (German #BEZUG)

I believe it should work but I can't see why it doesn't

thx in advance

--
Martin

First of all, there must be no apostrophes around the path and sheet name.

Second, Indirect only works for open files.

"Martin Hallerbach" wrote:


Hi NG,

I try the following

J10 = contans a literal which is
1. a Productnumber XXXXXX
2. the name of a table that contains parts, concerned to the product.

in N10
=ADRESS(10;1;1;TRUE;"\\Server\Path\["&J10&".xls]Titelseite")
gives me the completed adress as text
'\\Server\Path\[XXXXXX.xls]Titelseite'!$A$10

Now i'm looking for a function to retrieve the value of that specific cell

I try in N11
=INDIRECT(N10)

but i get an error back
#REFERENCE (German #BEZUG)

I believe it should work but I can't see why it doesn't

thx in advance

--
Martin

Hi Bob and Martin,

thanks for your information.

I'll try that VBA code

:-))))

--
Martin


"Bob Phillips" wrote:

You cannot use INDIRECT on a closed workbook. For this try this alternative
http://makeashorterlink.com/?F2993260A

--