vba filename code example

Example: excel vba get the workbook full filename with path

MsgBox ThisWorkbook.FullName