Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Function or formula to show currently active workbook name in cell
Hi all. Excel 2007 / XP Pro.
Is there a function or formula that will display the currently active workbook name (without the path or filename extention) in a cell on the currently open sheet in that workbook? There will be other open workbooks. Appologies if this is a stupid question. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Function or formula to show currently active workbook name in cell
One way
=MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,FIND("]",CELL("filename",A1))-FIND("[",CELL("filename",A1))-1) Or see: http://www.ozgrid.com/VBA/WorkbookPath.htm -- Regards Dave Hawley www.ozgrid.com "Wes_A" wrote in message ... Hi all. Excel 2007 / XP Pro. Is there a function or formula that will display the currently active workbook name (without the path or filename extention) in a cell on the currently open sheet in that workbook? There will be other open workbooks. Appologies if this is a stupid question. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Screen scrolling to show active cell | Excel Programming | |||
Function or Formula to show the value from above cell | Excel Worksheet Functions | |||
Click to show value in active cell | Excel Programming | |||
How to show the active cell after running a macro? | Excel Programming | |||
Only want color to show when cell is active | Excel Worksheet Functions |