Linking to Data from Multiple Workbooks

[hun1997]

Hi All -- I'm having a little trouble wrapping my mind around this one
so maybe someone has an idea.

I have a few workbooks: a.xls, b.xls, c.xls, etc. that contain larg
amounts of data. Each workbook is identical in structure, however eac
contains different data.

Now I want to create a new workbook that pulls only a small amount o
data from each workbook (depending on the value of dropdown list) an
displays the data (and possibly creates a graph, etc.).

What is the best way to deal with the different file paths, etc.?
Either through Excel functions or VB?

Thanks all

 

[hun1997]

And what do you know -- a little more time towards searching and I foun
my answer I believe:

http://www.excelforum.com/showthread.php?s=&threadid=179330&highlight=file+paths

This forum is great.

Sorry for the "double" post