Prev: Excel 2007 is Slow
Next: Totalling data from different sheets.
From: Wes_A on 12 Apr 2010 04:21
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.
From: ozgrid.com on 12 Apr 2010 05:00
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" <WesA(a)discussions.microsoft.com> wrote in message
news:C249074D-65EF-4593-AA6B-410AF8EE5BA4(a)microsoft.com...
> 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.

 | 
Pages: 1
Prev: Excel 2007 is Slow
Next: Totalling data from different sheets.