I have a full file path and I want to extract only part of the path
using the VBA split function.
For example, in C:\windows\excel\archives\blah.xls I want to extract
"\excel\archives" only.
I have the C:\windows already in another cell. So basically I just
want to cut off this part as well as the file name to give me my
relative path. Any suggestions?
Bookmarks