Hi,

='C:\[Budget 2006.xls]Mysheet'!$E$12

This is OK, however, how do I control eht filename dynamically? In
other words, I want a cell that controls the filename. I haven't found
a way to do this....

--
JF

=indirect() will let you reference a cell or name and return it as a proper
reference.The destination workbok must be open for it to work
--
paul

remove nospam for email addy!



" wrote:

Hi,

='C:\[Budget 2006.xls]Mysheet'!$E$12

This is OK, however, how do I control eht filename dynamically? In
other words, I want a cell that controls the filename. I haven't found
a way to do this....

--
JF

Thanks for your answer!

I assume then that there is no way to link dynamically to a closed
workbook without using some kind of macro.

Thanks
JF


paul wrote:
=indirect() will let you reference a cell or name and return it as a proper
reference.The destination workbok must be open for it to work
--
paul

remove nospam for email addy!



" wrote:

Hi,

='C:\[Budget 2006.xls]Mysheet'!$E$12

This is OK, however, how do I control eht filename dynamically? In
other words, I want a cell that controls the filename. I haven't found
a way to do this....

--
JF

Harlan Grove wrote a UDF called PULL that will retrieve the value from a closed
workbook.

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.

wrote:

Thanks for your answer!

I assume then that there is no way to link dynamically to a closed
workbook without using some kind of macro.

Thanks
JF

paul wrote:
=indirect() will let you reference a cell or name and return it as a proper
reference.The destination workbok must be open for it to work
--
paul

remove nospam for email addy!



" wrote:

Hi,

='C:\[Budget 2006.xls]Mysheet'!$E$12

This is OK, however, how do I control eht filename dynamically? In
other words, I want a cell that controls the filename. I haven't found
a way to do this....

--
JF



--

Dave Peterson

Thanks a lot Dave!
Great resources!

JF

Dave Peterson wrote:
Harlan Grove wrote a UDF called PULL that will retrieve the value from a closed
workbook.

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.

wrote:

Thanks for your answer!

I assume then that there is no way to link dynamically to a closed
workbook without using some kind of macro.

Thanks
JF

paul wrote:
=indirect() will let you reference a cell or name and return it as a proper
reference.The destination workbok must be open for it to work
--
paul

remove nospam for email addy!



" wrote:

Hi,

='C:\[Budget 2006.xls]Mysheet'!$E$12

This is OK, however, how do I control eht filename dynamically? In
other words, I want a cell that controls the filename. I haven't found
a way to do this....

--
JF



--

Dave Peterson