vba: get location of current worksheet
- by every_answer_gets_a_point
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)