get filename and filepath

Robert Ehrlich · Dec 21, 2003

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

Who can help?

Robert

J.E. McGimpsey · Dec 21, 2003

One way:

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

Stuart · Dec 21, 2003

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

Chip Pearson · Dec 21, 2003

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

get filename and filepath

Robert Ehrlich

J.E. McGimpsey

Stuart

Chip Pearson