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.