Thread: Application.Path (Getting the directory that my workbook is in)
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jan Karel Pieterse Jan Karel Pieterse is offline
external usenet poster
  
Posts: 535
Default 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

Reply With QuoteReply With Quote