vba active workbook code example

Example: vba active workbook path

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