Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do you make the INFO("directory") function work?
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do you make the INFO("directory") function work?
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 ToolsOptionsGeneralDefault 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 "TimR" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I can't make the "unhide column" work in 2007 Excell | New Users to Excel | |||
INFO("directory") function | Excel Worksheet Functions | |||
Retrieving info from "child" to a "parent" document | Excel Discussion (Misc queries) | |||
how can I make an excel cell "mark" or "unmark" when clicked on? | Excel Discussion (Misc queries) | |||
Can't make Excel "if" Formula work | Excel Worksheet Functions |