INFO("directory") Funtion

[TimR]

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.

This function should read the directory every time the file is opened or
saved. Is there a fix available for this issue?

 

[HelpExcel.com]

Tim,

You could use the FSO (File System Object) to ensure you get the correct path.