Problem linking to new file

  • Thread starter Thread starter Johan Myrén
  • Start date Start date
J

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
 
That help a part of the way no I get a #ref! instead.

Max said:
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 said:
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
Click to expand...
Click to expand...
 
That helped some but now I get a #ref! instead.

Max said:
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 said:
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
Click to expand...
Click to expand...
 
Johan Myrén said:
That helped some but now I get a #ref! instead
Click to expand...

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
---
 
Back
Top