Filename in a cell

[phica dk]

How do I get only the filename of the active workbook into a cell.
The "CELL" function returns the name including the whole path.

 

[Ron de Bruin]

Hi phica

Look here
http://www.xldynamic.com/source/xld.xlFAQ0002.html

 

[JE McGimpsey]

Take a look here:

Worksheet and Workbook names using the CELL() function:
http://www.mcgimpsey.com/excel/formulae/cell_function.html

 

[anilsolipuram]

Public Function getfilepath()
getfilepath = ActiveWorkbook.Path & "\" & ActiveWorkbook.Name
End Function

create the the above function and call from your cell by using

formulae =getfilepath()