Formula for Pathname and Excel Filename

[Turbo_Beagle]

Does anyone know the formula to put in a cell that will display the path and filename of the current excel spreadsheet?

[VBA Noob]

Hi,

These formulas from pearson site

=CELL("filename",A1) Returns the full sheet name (including the file path)

=LEFT(CELL("filename",A1),FIND("]",CELL("filename",A1)))
or
=SUBSTITUTE(SUBSTITUTE(LEFT(CELL("filename",A1),FIND("]",
CELL("filename",A1))),"[",""),"]","")

returns the file name with the path

http://www.cpearson.com/excel/excelF.htm


VBA Noob