Application.Path (Getting the directory that my workbook is in)

[Richard1284]

Hi all,

Just a quick quesion, upon using Application.Path I am getting th
windows directory that MS excel is stored in. Is this what I should b
getting? If so then how do I get the path of the directory that m
workbook is in??

 

[Jan Karel Pieterse]

Hi Richard1284,

If so then how do I get the path of the directory that my
workbook is in???

Workbooks("YourBooksName").Path

Or

ActiveWorkbook.Path

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com