Use filename in cell to link data

H

HughT

I have a folder with 12 excel files. The first one in the range has a list of
filenames that I need to link to to retrieve specific data. How can I create
a link to external xls files using the filenames in COL F in the first file?
 
A

Arvi Laanemets

Hi

You can use INDIRECT to compose the cell/range references - so long as all
source workbooks are opened along with your workbook. When the latter isn't
an option, you have to use some UDF (from time to time a link which provides
one appears in Excel NG's), or some VBA procedure to rewrite formulas
accordingly your files list.
 
H

HughT

Thank you for your response. I need to look up the list of filenames in "Col
F' in the first data file to open the corresponding files. I tried
"Workbooks.Open Filename' but can only open the first file in the list.
 
Top