Using the INFO("directory") function returns the correct path when initially
created. However, if the workbook is moved, the resultant value still
reflects to original path to the work book. This will be refreshed if the
work book is saved using the "save as" method but will revert to the original
value if the workbook is closed and reopened.

I am using Excel 2007.

I think the function gives you the current directory, not the directory in
which the file is stored.
--
Gary''s Student - gsnu200851


"TimR" wrote:

Using the INFO("directory") function returns the correct path when initially
created. However, if the workbook is moved, the resultant value still
reflects to original path to the work book. This will be refreshed if the
work book is saved using the "save as" method but will revert to the original
value if the workbook is closed and reopened.

I am using Excel 2007.

This retrives the default path not workbook path. Try this in a workbook
which is not saved...
--
If this post helps click Yes
---------------
Jacob Skaria


"TimR" wrote:

Using the INFO("directory") function returns the correct path when initially
created. However, if the workbook is moved, the resultant value still
reflects to original path to the work book. This will be refreshed if the
work book is saved using the "save as" method but will revert to the original
value if the workbook is closed and reopened.

I am using Excel 2007.