Accessing cells in other files

[johanfo]

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....

 

[paul]

=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

 

[johanfo]

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

=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
[email protected]
remove nospam for email addy!

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....

 

[Dave Peterson]

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.

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

=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
[email protected]
remove nospam for email addy!

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....

 

[johanfo]

Thanks a lot Dave!
Great resources!

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.

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

=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
[email protected]
remove nospam for email addy!



:

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....