Unfortunately that returns a type mismatch error.

Folder Name
D:\Test\Test This is short name
D:\Test\Test\SubTest This is a very long file ...... name
D:\Test This is an very very long .......................... file name
D:\Test This is a short name

need to return 2 in the example above