Filename in a cell
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 |
All times are GMT +1. The time now is 03:56 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com