Link to home
Start Free TrialLog in
Avatar of littlezane
littlezane

asked on

How to get the current file's directory in macro?

In Excel, how do I get the directory name of the present Excel file that contains this macro itself? When I use curDir(), it points to the "document" directory as the the present directory, not the directory the file itself resides in. Please help me.
ASKER CERTIFIED SOLUTION
Avatar of Patrick Matthews
Patrick Matthews
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of littlezane
littlezane

ASKER

Thanks, Patrick.