Tips & Tricks 156 – Get Workbook's Directory from Formula

If your workbook is located in say C:\Excel\MyDocs, the formula to retrieve the directory for this would be

=LEFT(CELL("filename",A1),FIND("[",CELL("filename",A1))-2)

Note – For this formula to work, you workbook must be saved at least once.