Ron I hate to abuse your help but I'm semi-desperate!
I got the indirect.ext funcion from the site you recommended (Thanks!) but
I'm wondering if I am phrasing my question correctly also...
In cell A1 I want to have the text: 06 JAN 2007.xls
and in my formula I want to use the reference to cell A1.
Am I making sense? I'm past being able to figure this out myself!
"Ron de Bruin" wrote:
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?