<div>
=CELL(&quot;filename&quot;; A2)
</div>


<div>
more details on the CELL function:<br />
<a href="http://office.microsoft.com/en-001/excel-help/cell-function-HP010062392.aspx" rel="ugc">http://office.microsoft.com/en-001/excel-help/cell-function-HP010062392.aspx</a><br />
<br />
note: as long as the workbook was not saved, this function will return empty
</div>


more details on the CELL function:
http://office.microsoft.com/en-001/excel-help/cell-function-HP010062392.aspx [http://office.microsoft.com/en-001/excel-help/cell-function-HP010062392.aspx]

note: as long as the workbook was not saved, this function will return empty

<div>
Define <b>WorkbookName</b><br />
<br />
RefersTo: <b>=GET.DOCUMENT(88)</b><br />
<br />
in A1<br />
<br />
=WorkbookName<br />
<br />
It'll give you even if the workbook is not saved.<br />
<br />
Kris
</div>


Define WorkbookName

RefersTo: =GET.DOCUMENT(88)

in A1

=WorkbookName

It'll give you even if the workbook is not saved.

Kris

<div>
Thanks Guy. It's almost what I want, except I don't want the full file path. Only the filename. Is this possible ?
</div>


Thanks Guy. It's almost what I want, except I don't want the full file path. Only the filename. Is this possible ?

<div>
Read the sentence as &quot;It'll give you the workbook name even if the workbook is not saved.&quot;<br />
<br />
Somehow I couldn't edit my post.
</div>


Read the sentence as "It'll give you the workbook name even if the workbook is not saved."

Somehow I couldn't edit my post.

<div>
Kris<br />
<br />
Here's the define...<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2014/11_w46/882580/Define-screenshot.PNG" target="_blank" title="Screenshot of the define details for WorkbookName (33 KB)"><img alt="Screenshot of the define details for WorkbookName" class="file-block lazyload" style="max-width: 567px;" data-src="https://filedb.experts-exchange.com/incoming/2014/11_w46/882580/Define-screenshot.PNG" /></a><br />
But I'm getting a #NAME? error in the cell.
</div>


Kris

Here's the define...

Screenshot of the define details for WorkbookNamehttps://filedb.experts-exchange.com/incoming/2014/11_w46/882580/Define-screenshot.PNG
But I'm getting a #NAME? error in the cell.

Screenshot of the define details for WorkbookName

Define-screenshot.PNG

<div>
Whoops ! Yep you were right. Thanks for that. Works great.
</div>


Whoops ! Yep you were right. Thanks for that. Works great.

<div>
<div class="content wysiwyg-content">
Hi All,<br />
<br />
Is there an Excel function I can use to display the name of the workbook currently open. Or can this only be done in VBA ?<br />
<br />
Thanks<br />
T
</div>
</div>


Hi All,

Is there an Excel function I can use to display the name of the workbook currently open. Or can this only be done in VBA ?

Thanks
T

Is there an Excel function to display the active workbook name in a cell ?

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.