Saturday, October 29, 2016

get path of current workbook

get path of current workbook
  • for just the path itself (without the workbook name)
    • Application.ActiveWorkbook.Path
  • for the path with the workbook name
    • Application.ActiveWorkbook.FullName

No comments:

Post a Comment