link to dynamic file name

realas

New Member
Joined
Oct 16, 2006
Messages
1
want to write link:
=[A7]Sheet1'!D2, where in cell A7 is 1_2_2006_10_19.xls it's a file name and i need to get data from 1_2_2006_10_19.xls file D2 cell. i can't write concrete link or file name ='[1_2_2006_10_19.xls]Sheet1'!D2, instead of [A7], because it will be changed next time. it will be, for example 4_5_2006.xls
 

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,547
You can change all the links to a particular file to be directed to another file in one go with Edit/Links/Change source command.

Otherwise you are going to need an add-in from Laurent Longre ( Morefunc.dll ) which includes the INDIRECT.EXT function ... see here:

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

Forum statistics

Threads
1,140,941
Messages
5,703,292
Members
421,290
Latest member
java

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top