You just need the Name property:

ActiveWorkbook.Name

which will give you "AWorkbook.xls"

Best regards

John


"bobwilson" wrote
in message ...

How do I automate the Master Workbook Name being added to a cell in my
worksheet. Right now I manually type it. The ActiveWorkbook.FullName
does not work as it is the full file path.

Dim masterWB As String ' Master Workbook Name
masterWB = Range("C138") ' C138 is the Workbook Name


--
bobwilson
------------------------------------------------------------------------
bobwilson's Profile:
http://www.excelforum.com/member.php...o&userid=33046
View this thread: http://www.excelforum.com/showthread...hreadid=529596