Quote:
Originally Posted by neilwhite
Thanks so much for this, it’s massively appreciated. I have had a quick play and it looks pretty much spot on. One issue is that each header shows the full pile path not just that header.
|
That was intentional - it wasn't apparent from your specs as to how much was to be retained. To get just the file's own folder, change:
.InsertAfter vbCr & strRelPath & vbCr
to:
.InsertAfter vbCr & Split(strRelPath, "")(h - 2) & vbCr