vba take name of file code example

Example: excel vba get the workbook full filename with path

MsgBox ThisWorkbook.FullName