Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
name of another worksheet in cell for reference | Excel Worksheet Functions | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |