Selina,

You can use the following:

Dim strFullName as String
strFullName = ActiveWorkbook.FullName
MsgBox strFullName

HTH

"Selina" wrote:

> How do I get the full path of the Excel workbook that is open and active ?
> File System Object requires the full path before opening, creating and
> manipulating files. What if the path is "unknown" ? I am trying to put the
> path and workbook name and worksheetname into the footer of each sheet of the
> active workbook. Thank you.