vba active workbook path code example

Example 1: excel vba get the workbook full file name with path

MsgBox ThisWorkbook.FullName

Example 2: vba active workbook path

Application.ActiveWorkbook.Path      ' just the path itself (directory)
Application.ActiveWorkbook.FullName  ' path with the workbook name.