Linking cells

I have a file named " A 4-2-08". I create new files on a weekly basis
with 
the name changing from " A 4-2-08" to " A 4-09-08", "A
4-16-08"  etc.  File 
"B " has a cell that links a cell from file "A" but I want
the current file 
to be called on. How can I have file "B" call on  the current file
"A" 
without constantly changing the formula in file "B"  to call on the
latest 
"A" file?   Thank you. 

Using a static linked filename would be a good method as Roy detailed.

If you use a string built link then it will only show results when the 
linked file is open.  Otherwise, ERR is shown.  Of course you can hide 
the linked files.  An open macro could automate that for you.

If your linked filenames was stored as c:\myfiles\qpro\ww.qpw and the 
cell of interest was A:B5 then a formula might be:

@@("[c:\myfiles\qpro\ww]"&"A:B5")
or more simply:
@@("[ww]"&"A:B5")

Of course you can quickly open linked files by Edit > Links.  However, 
there are no HotLinks if you use the string built link method.

A macro could automate the renaming to a static linked filename for 
method 1 if used.

Bob:
> I have a file named " A 4-2-08". I create new files on a weekly
basis with 
> the name changing from " A 4-2-08" to " A 4-09-08",
"A 4-16-08"  etc.  File 
> "B " has a cell that links a cell from file "A" but I
want the current file 
> to be called on. How can I have file "B" call on  the current
file "A" 
> without constantly changing the formula in file "B"  to call on
the latest 
> "A" file?
>
The easiest solution is to call the current file by some unchanging name. When 
it is no longer current, you can rename it to your date format.
-- 
Good wishes!
Roy Lewis
C_Tech volunteer
(UK)