Thread: Path where Workbook is saved
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
mudraker[_46_] mudraker[_46_] is offline
external usenet poster
  
Posts: 1
Default Path where Workbook is saved

Range("a1") = ThisWorkbook.Path

or

Range("a1") = ActiveWorkbook.Pat

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements
Reply With QuoteReply With Quote