How to get the path of current worksheet in VBA

Question

I wrote a macro as an add-in  and I need to get the path of the current worksheet on which it is being executed  How do I do this  How do I get the file path  just the directory

User · Accepted Answer

Use Application ActiveWorkbook Path for just the path itself  without the workbook name  or Application ActiveWorkbook FullName for the path with the workbook name

User · Answer

If you want to get the path of the workbook from where the macro is being executed - use Application ThisWorkbook Path  Application ActiveWorkbook Path can sometimes produce unexpected results  e g  if your macro switches between multiple workbooks

User · Answer

Always nice to have    Dim myPath As String      Dim folderPath As String   folderPath   Application ActiveWorkbook Path     myPath   Application ActiveWorkbook FullName

User · Answer

The quickest way path   ThisWorkbook Path  amp   quot   quot

[excel] How to get the path of current worksheet in VBA?

Examples related to excel

Examples related to vba