[Løst] Excel: Hente inn filnavnet i celle?

[koda]

Fins det en formel for å hente navnet på excel-filen inn i en celle?

[Snasnt]

Insert the current file name, its full path, and the name of the active worksheet (for example, C:\Excel\[test.xls]Testsheet)

 

Enter the following formula in the cell in which you want to display the current file name with its full path and the name of the current worksheet:

=CELL("filename")

Insert the current file name and the name of the active worksheet (for example, [text.xls]Testsheet)

 

Enter the following formula as an array formula to display the current file name and active worksheet name:

=RIGHT(CELL("filename"),LEN(CELL("filename"))- MAX(IF(NOT(ISERR(SEARCH("\",CELL("filename"), ROW(1:255)))),SEARCH("\",CELL("filename"),ROW(1:255)))))

[Harald Staff]

Forutsetter engelsk Excel siden du ikke spesifiserer:

 

=MID(CELL("filename");FIND("[";CELL("filename"))+1;(FIND("]";CELL("filename"))-FIND("[";CELL("filename"))-1))

 

HTH. Beste hilsen Harald

Endret 9. mars 2011 av Harald Staff

[koda]

Takker:)