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

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??

--
Message posted from http://www.ExcelForum.com

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

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