Problem linking to new file

[Johan Myrén]

My problem is that I want to have a link to a cell in a different workbook.
The cell is always the same but it's different files, the title of the new
file is the information in the A column followed by -BOM.xls.

All files are placed in the same folder.

My formula written in D2 is like bellow
="'\\se-ka-sr028\roxtec-se\Global
Technology\TPO\DO-BOM\["&A2&"-BOM.xls]Sheet1'!$G$5"
but I cant get it to work.

Best regards Johan

 

[Max]

Try removing the double quotes wrapping the link formula ?
It shouldn't be part of the actual expression
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik

 

[Johan Myrén]

That help a part of the way no I get a #ref! instead.

Try removing the double quotes wrapping the link formula ?
It shouldn't be part of the actual expression
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
---

My problem is that I want to have a link to a cell in a different workbook.
The cell is always the same but it's different files, the title of the new
file is the information in the A column followed by -BOM.xls.

All files are placed in the same folder.

My formula written in D2 is like bellow
="'\\se-ka-sr028\roxtec-se\Global
Technology\TPO\DO-BOM\["&A2&"-BOM.xls]Sheet1'!$G$5"
but I cant get it to work.

Best regards Johan

 

[Johan Myrén]

That helped some but now I get a #ref! instead.

Try removing the double quotes wrapping the link formula ?
It shouldn't be part of the actual expression
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
---

My problem is that I want to have a link to a cell in a different workbook.
The cell is always the same but it's different files, the title of the new
file is the information in the A column followed by -BOM.xls.

All files are placed in the same folder.

My formula written in D2 is like bellow
="'\\se-ka-sr028\roxtec-se\Global
Technology\TPO\DO-BOM\["&A2&"-BOM.xls]Sheet1'!$G$5"
but I cant get it to work.

Best regards Johan

 

[Max]

That helped some but now I get a #ref! instead

Think I mis-read it earlier, sorry. What you're trying to do is not possible
with the source file closed. It needs to be open simultaneously and the link
formula needs to be composed within INDIRECT in the other file.

Eg in Book1.xls
you have this link in B2: =[Book2]Sheet1!A2
with Book2.xls simultaneously open

If you want to make the above flexible to the filename
where filename is specified in A2, eg in A2 is : Book2
then this in B2: =INDIRECT("'["&A2&"]Sheet1'!A2")
will work to return the same link

If A2 is changed to: Book3, and assuming Book3.xls is open as well, then B2
will now point to Book3 instead, and return the same as: =[Book3]Sheet1!A2
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
---