Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Linking with text string
=Indirect("'C:\acc\[" &f1&".xls]Section A'!H4")
would be the way to do it, but Indirect doesn't work with a closed workbook. So you would need to use code to build your string and hard code it in the cell. -- Regards, Tom Ogilvy "Nigel Chapman" wrote in message news:1063794461.820256@dyfi... I wonder if anyone can help me. What I want to do is to be able to link to another file using a text string picked up from my current sheet. In the example below, which doesnt work, cell F1 contains my file name, and the effect I want to achieve is : ='C:\acc\[data.xls]Section A'!H4 ='C:\acc\[" &f1&".xls]Section A'!H4 where FI contains the string "data" Is it possible to include strings in linking like this? Any help greatly appreciated. Thanks Nigel |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text string to Numeric string | Excel Discussion (Misc queries) | |||
Nested formula to search a text string and return specific text | Excel Worksheet Functions | |||
Change 3 letter text string to a number string | Excel Discussion (Misc queries) | |||
Splitting a text string into string and number | Excel Discussion (Misc queries) | |||
want to remove all text characters equal to one character in length from text string | Excel Worksheet Functions |