MsgBox ActiveWorkbook.FullName, vbInformation, 'Workbook Complete Path' You can use the following code to get Active Workbook FullName to know the location of workbook. You can use ActiveWorkbook property to return the active workbook FullName. MsgBox ActiveWorkbook.Path, vbInformation, 'Workbook Path' You can use ActiveWorkbook property to return the active workbook Path.You can use the following code to Get Active Workbook Path to know the workbook directory. MsgBox ActiveWorkbook.Name, vbInformation, 'Workbook Name'
You can use the following code to get the name of the Active Workbook Code: You can use ActiveWorkbook property to return the active workbook name. Get Active Workbook or Worksheet Name – Example Cases: You can get Active Workbook Or Worksheet Name by using Name property of the workbook or worksheet. When we are working with workbooks and worksheets, some times we may required to Get Active Workbook or Worksheet Name, Path of the workbook to know the directory, FullName(Complete path) of the workbook to know the location of the workbook, selected Range address in active sheet or selected Cell address in active sheet using Excel VBA.
