Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
How do you make the INFO("directory") function work?
101 views
Skip to first unread message
TimR
Nov 12, 2009, 7:38:04 PM11/12/09
to
The INFO("directory") function displays the default directory instead of the
directory that the work book is saved in. I have succeeded in getting the
function to report the correct directory if a "Save As" command is used, but
closing the workbook and excel and then reopening excel and the workbook
agains shows the results as the default directory instead of the directory
that the workbook is saved in.
directory that the work book is saved in. I have succeeded in getting the
function to report the correct directory if a "Save As" command is used, but
closing the workbook and excel and then reopening excel and the workbook
agains shows the results as the default directory instead of the directory
that the workbook is saved in.
Jacob Skaria
Nov 12, 2009, 8:20:01 PM11/12/09
to
INFO() returns information about the current operating environment and not
the path of the current workbook. This is the same as what is mentioned in
Tools>Options>General>Default file location
the path of the current workbook. This is the same as what is mentioned in
Tools>Options>General>Default file location
If you are looking to get the workbook path you can use the below..(make
sure you try this in a saved workbook)
=LEFT(CELL("filename",A1),FIND("[",CELL("filename",A1))-1)
If this post helps click Yes
---------------
Jacob Skaria
0 new messages