Indirect function

[Libby]

I have the following formula to try and link to a cell in another workbook
but want to reference a new cell each day. I am getting a # ref. Can
somebody help with this please.

=INDIRECT("'"&$A$44&"'[mar MIR.xls]mid-city'!$g$39")

 

[Dave Peterson]

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.

I have the following formula to try and link to a cell in another workbook
but want to reference a new cell each day. I am getting a # ref. Can
somebody help with this please.

=INDIRECT("'"&$A$44&"'[mar MIR.xls]mid-city'!$g$39")

 

[Libby]

The workbook is open when I am using the function.
--
Libby

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.

I have the following formula to try and link to a cell in another workbook
but want to reference a new cell each day. I am getting a # ref. Can
somebody help with this please.

=INDIRECT("'"&$A$44&"'[mar MIR.xls]mid-city'!$g$39")

 

[Dave Peterson]

What's in A44?

Why not just:
=INDIRECT("'[mar MIR.xls]mid-city'!$g$39")

or drop the =indirect() completely
='[mar MIR.xls]mid-city'!$g$39

The workbook is open when I am using the function.
--
Libby

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.

I have the following formula to try and link to a cell in another workbook
but want to reference a new cell each day. I am getting a # ref. Can
somebody help with this please.

=INDIRECT("'"&$A$44&"'[mar MIR.xls]mid-city'!$g$39")