How do you make the INFO("directory") function work?

[TimR]

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.

 

[Jacob Skaria]

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

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