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

Hi phica

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

--
Regards Ron de Bruin
http://www.rondebruin.nl


"phica dk" <phica wrote in message ...
How do I get only the filename of the active workbook into a cell.
The "CELL" function returns the name including the whole path.

Take a look he

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


In article ,
"phica dk" <phica wrote:

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

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

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

formulae =getfilepath()


--
anilsolipuram
------------------------------------------------------------------------
anilsolipuram's Profile: http://www.excelforum.com/member.php...o&userid=16271
View this thread: http://www.excelforum.com/showthread...hreadid=313846