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

Richard1284 · May 25, 2004

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 · May 25, 2004

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