recalc question

  • Thread starter Thread starter Bura Tino
  • Start date Start date
B

Bura Tino

Hi,

I have a function thisbookname() which returns the full path name of
the file. However, if the file is moved to another directory and then
opened, the content of the =thisbookname() cell is not updated. F9
does not change the value. Nor does the VBA "Recalculate" command.

How to fix this?

Thanks!

Bura
 
Bura,

Excel doesn't keep track of where it was "opened from"
It does keep track of where it was "saved last".
If you move the file and then open it, it thinks that it's still
in the old location. If you save the file in the directory from
which it was opened, your function should work correctly.

John
 
OK, so what do I do in the scenario when the file is moved and then
opened from a different directory? Or, better still, emailed to
someone?

How about a kluge: thisbookname(rand())?
 
Back
Top