View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] johanfo@gmail.com is offline
external usenet poster
 
Posts: 3
Default Accessing cells in other files

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