The macro doesn't quite work for me the way being able to refer to a name
would.... Any suggestions there?

"Ron de Bruin" wrote:

Hi Michael in Texas

Maybe you can use this macro to select the files and create the links for you
http://www.rondebruin.nl/summary2.htm

See example 2 that also test if the files is already in the list

Ron from Holland

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Michael in Texas" wrote in message
...
I need to link to workbooks whose names will be constantly changing. I want
to access a data file that has labor cost info such as hours worked,
overtime, wages, etc. Each week I need to print reports based on this info
that will communicate to the production team how they are doing. The problem
is that these files will have a new name each week: 06 JAN 2007, then 12 JAN
2007, etc.

So in my report worksheet I want to just type the name of the new file into
a cell and use the cell reference to build my formulas. So in Cell A1 I
would type the name of the new file. And in buiilding my formulas I will
tell the cell to look for the worksheet named "new file name" and then go to
this tab; etc.

Any ideas?