All,

I have the following line of code which gets the full path (iPath) of a file
(iFile) from a Root directory (sRoot)

Cells(iFile, iPathCol).Value = Mid(oFile.Path, Len(sRoot) + 1,
FindBack(oFile.Path, "\") + 1 - (Len(sRoot) + 1))

I want to split it, so that the first folder in the path is displayed under
iPathCol1
and the remainder of the path is displayed in iPathCol2.

I don't understand the part after the equals sign!

Can provide a solution for me.

Thanks in advance.

DDawson