Given the following path:

s = Excel.ActiveWorkbook.Path

how can I find the parent folder 3 levels up?


Eg if s = p:\paydata\hrimp\library\monthlystats\2005\12\Chie fExec

i want to be able to return p:\paydata\hrimp\library\monthlystats

I could do it by searching for the \ characters from the end of the
string, but it is there any easier way to do this?

Nirmal Singh