being able to refer to a name
Not possible with closed workbooks
The Indirect function is only working with open workbooks.


You can try this two links and see if it can do what you want

You can find the function at Harlan's FTP site:
ftp://members.aol.com/hrlngrv/
Look for pull.zip


Laurent Longre has an addin (morefunc.xll) at:
http://xcell05.free.fr/

That includes =indirect.ext() that may help you.



--

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


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