activeworkbook.FullName

However, in View=>Header Footer, choose custom, the button with the folder
icon will put in the full path and Name (in xl2003 and as I recall, it was
there in earlier versions as well - but I could be wrong).

Not sure how this relates to filesystemobject.

--
Regards,
Tom Ogilvy


--
Regards,
Tom Ogilvy

"Selina" <Selina@discussions.microsoft.com> wrote in message
news:82D73904-FDE4-40A8-B2B3-8B4B1AA6E30B@microsoft.com...
> 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.