Hi,

The first line puts the name in a cell the second one puts the full path and
name

Sheets("Sheet1").Range("A1") = ThisWorkbook.Name
Sheets("Sheet1").Range("A2") = ThisWorkbook.FullName
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"confused" wrote:

In excel vba I want to add a line that displays the name of the workbook on a
summary sheet

Is there an automatic way to add the name without typing it in

here's what I have so far:
'Enter Name
.Range ("B1") = "NAME"

Thank you in advance !!!