Thread: How to ascertain path of file in adjacent directory hierarchy
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paul Martin Paul Martin is offline
external usenet poster
  
Posts: 114
Default How to ascertain path of file in adjacent directory hierarchy
For anyone interested, I have found a solution as follows:

Dim sPath as String

sPath = ThisWorkbook.Path & "\..\DIR_2"

Paul Martin
Melbourne, Australia

Reply With QuoteReply With Quote