vba: get location of current worksheet

Posted by every_answer_gets_a_point on Stack Overflow See other posts from Stack Overflow or by every_answer_gets_a_point
Published on 2010-05-11T19:42:38Z Indexed on 2010/05/11 19:54 UTC
Read the original article Hit count: 156

Filed under:
|
|

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)

© Stack Overflow or respective owner

Related posts about vba

Related posts about excel-vba