Use filename in cell to link data
 

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?

Use filename in cell to link data
 

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.


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )


"HughT" wrote in message
...
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?

Use filename in cell to link data
 

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.

"Arvi Laanemets" wrote:

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.


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )


"HughT" wrote in message
...
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?