INFO("directory") function
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. |
INFO("directory") function
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. |
INFO("directory") function
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. |
All times are GMT +1. The time now is 07:49 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com