vba: get location of current worksheet

Question

i wrote a macro that is an add=in

it needs to figure out the location of the current worksheet on which it is being executed. how do i do this?

i need the file location (directory)

Answer 1

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