Robert,
Use the Path and FullName properties of the Workbook object. For
example,
Debug.Print ThisWorkbook.Path, ThisWorkbook.FullName
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"Robert Ehrlich" wrote in message
...
How can I get my own filename and filepath?
Is there any function which provides this?
Who can help?
Robert