INFO("directory") Funtion

T

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?
 
H

HelpExcel.com

Tim,

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top