Cell containing it's workbooks' filename

**Cumberland** · 03-15-2007, 10:40 AM

Can a cell contain the filename of its workbook?

IE: If workbook's filename is "My Spreadsheet.xls", can cell A1 contain a formula so that it displays this in the cell?

Thanks,

**oldchippy** · 03-15-2007, 10:46 AM

For any of these to work the workbook must be saved first

=CELL("filename",A1) - Full file path, including worksheet name

=LEFT(CELL("filename",A1), FIND("]",CELL("filename", A1))) - Full file path

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

=MID(LEFT(CELL("filename",A1), FIND("]", CELL("filename", A1))- 1), FIND("[",CELL("filename", A1))+1, 255) - File name only

=MID(CELL("filename",A1), FIND("]", CELL("filename", A1))+ 1, 255) - Worksheet name only