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.

If that's a problem, then Laurent Longre has an addin (morefunc.xll) at:
http://xcell05.free.fr/
or
http://xcell05.free.fr/morefunc/english/index.htm

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

Paul Peterson - Velox Consulting, LLC wrote:

I have a formula that references another excel workbook. The name of this
workbook will be different depending on the date. Yesterday, I summed
numbers from C:/Testing/Errors - 021609; today I will sum numbers from a
different workbook named C:/Testing/Erros - 021709. In my worksheet, I have
to manually change the reference to reflect the current date. Is there a way
to make that name variable based on today's date? Any help would be
appreciated.

Paul Peterson
Velox Consulting, LLC

--

Dave Peterson

Hey Dave,
I pulled down the funcustomize.dll file from
http://xcell05.free.fr/english/index.html but I am having trouble
understanding how to hook it into my Excel 2003. I unzipped the file and
copied the contents to my C:\Documents and Settings\user\Application
Data\Microsoft\AddIns directory. In Excel I selected ToolsAdd-ins and
selected the Funcustomize option. However, when I go to insert a function I
don't see any of the funcustomize functions. Is there something else I need
to do to see these?

Thanks for your help.

"Dave Peterson" wrote:

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.

If that's a problem, then Laurent Longre has an addin (morefunc.xll) at:
http://xcell05.free.fr/
or
http://xcell05.free.fr/morefunc/english/index.htm

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

Paul Peterson - Velox Consulting, LLC wrote:

I have a formula that references another excel workbook. The name of this
workbook will be different depending on the date. Yesterday, I summed
numbers from C:/Testing/Errors - 021609; today I will sum numbers from a
different workbook named C:/Testing/Erros - 021709. In my worksheet, I have
to manually change the reference to reflect the current date. Is there a way
to make that name variable based on today's date? Any help would be
appreciated.

Paul Peterson
Velox Consulting, LLC

--

Dave Peterson

And if you start typing:
=indirect.ext(
and hit ctrl-shift-A, do you get any help?


tjfwestcoast wrote:

Hey Dave,
I pulled down the funcustomize.dll file from
http://xcell05.free.fr/english/index.html but I am having trouble
understanding how to hook it into my Excel 2003. I unzipped the file and
copied the contents to my C:\Documents and Settings\user\Application
Data\Microsoft\AddIns directory. In Excel I selected ToolsAdd-ins and
selected the Funcustomize option. However, when I go to insert a function I
don't see any of the funcustomize functions. Is there something else I need
to do to see these?

Thanks for your help.

"Dave Peterson" wrote:

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.

If that's a problem, then Laurent Longre has an addin (morefunc.xll) at:
http://xcell05.free.fr/
or
http://xcell05.free.fr/morefunc/english/index.htm

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

Paul Peterson - Velox Consulting, LLC wrote:

I have a formula that references another excel workbook. The name of this
workbook will be different depending on the date. Yesterday, I summed
numbers from C:/Testing/Errors - 021609; today I will sum numbers from a
different workbook named C:/Testing/Erros - 021709. In my worksheet, I have
to manually change the reference to reflect the current date. Is there a way
to make that name variable based on today's date? Any help would be
appreciated.

Paul Peterson
Velox Consulting, LLC

--

Dave Peterson


--

Dave Peterson

I pulled down the funcustomize.dll file

I think you grabbed the wrong file. You want the MOREFUNC.XLL file.

--
Biff
Microsoft Excel MVP


"Dave Peterson" wrote in message
...
And if you start typing:
=indirect.ext(
and hit ctrl-shift-A, do you get any help?


tjfwestcoast wrote:

Hey Dave,
I pulled down the funcustomize.dll file from
http://xcell05.free.fr/english/index.html but I am having trouble
understanding how to hook it into my Excel 2003. I unzipped the file and
copied the contents to my C:\Documents and Settings\user\Application
Data\Microsoft\AddIns directory. In Excel I selected ToolsAdd-ins and
selected the Funcustomize option. However, when I go to insert a
function I
don't see any of the funcustomize functions. Is there something else I
need
to do to see these?

Thanks for your help.

"Dave Peterson" wrote:

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.

If that's a problem, then Laurent Longre has an addin (morefunc.xll)
at:
http://xcell05.free.fr/
or
http://xcell05.free.fr/morefunc/english/index.htm

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

Paul Peterson - Velox Consulting, LLC wrote:

I have a formula that references another excel workbook. The name of
this
workbook will be different depending on the date. Yesterday, I
summed
numbers from C:/Testing/Errors - 021609; today I will sum numbers
from a
different workbook named C:/Testing/Erros - 021709. In my worksheet,
I have
to manually change the reference to reflect the current date. Is
there a way
to make that name variable based on today's date? Any help would be
appreciated.

Paul Peterson
Velox Consulting, LLC

--

Dave Peterson


--

Dave Peterson

I didn't.

But thanks for the correct response Biff.

"T. Valko" wrote:

I pulled down the funcustomize.dll file

I think you grabbed the wrong file. You want the MOREFUNC.XLL file.

--
Biff
Microsoft Excel MVP

"Dave Peterson" wrote in message
...
And if you start typing:
=indirect.ext(
and hit ctrl-shift-A, do you get any help?


tjfwestcoast wrote:

Hey Dave,
I pulled down the funcustomize.dll file from
http://xcell05.free.fr/english/index.html but I am having trouble
understanding how to hook it into my Excel 2003. I unzipped the file and
copied the contents to my C:\Documents and Settings\user\Application
Data\Microsoft\AddIns directory. In Excel I selected ToolsAdd-ins and
selected the Funcustomize option. However, when I go to insert a
function I
don't see any of the funcustomize functions. Is there something else I
need
to do to see these?

Thanks for your help.

"Dave Peterson" wrote:

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.

If that's a problem, then Laurent Longre has an addin (morefunc.xll)
at:
http://xcell05.free.fr/
or
http://xcell05.free.fr/morefunc/english/index.htm

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

Paul Peterson - Velox Consulting, LLC wrote:

I have a formula that references another excel workbook. The name of
this
workbook will be different depending on the date. Yesterday, I
summed
numbers from C:/Testing/Errors - 021609; today I will sum numbers
from a
different workbook named C:/Testing/Erros - 021709. In my worksheet,
I have
to manually change the reference to reflect the current date. Is
there a way
to make that name variable based on today's date? Any help would be
appreciated.

Paul Peterson
Velox Consulting, LLC

--

Dave Peterson


--

Dave Peterson

--

Dave Peterson