recalc question

[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

 

[John Wilson]

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

 

[Bura Tino]

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())?