get filename and filepath

[Robert Ehrlich]

How can I get my own filename and filepath?
Is there any function which provides this?

Who can help?


Robert

 

[J.E. McGimpsey]

One way:

=LEFT(CELL("filename",A1),FIND("]",CELL("filename",A1)))

 

[Stuart]

MsgBox ActiveWorkbook.Path & "\" & ActiveWorkbook.Name

 

[Chip Pearson]

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