get filename and filepath
 

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

Who can help?


Robert

get filename and filepath
 

One way:

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


In article ,
"Robert Ehrlich" wrote:

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

get filename and filepath
 

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


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

get filename and filepath
 

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