=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