If starting on a cell such as D7, how do I reference a PARTIAL folder path listed in cell F7? The path will vary in how many subfolders it has. I simply want to reference the path MINUS the last subfolder. (e.g. \\foldler1\folder2\FolderIDon'tWantToReference, but remember the names of the...