The function you'd want to use that's built into excel is =indirect(). But that
function returns an error if the sending workbook is closed.

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

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

pwk wrote:

I am trying to link to another workbook to extract data daily. The
problem is the page name changes on a daily basis. Can I use wildcards

to do this? Maybe there's another way. Here are the references:

'[DOC - Daily Composite.xls]142007, 1'!$F$381

'[DOC - Daily Composite.xls]742996, 1'!$F$381

Thanks!

--

Dave Peterson