I have a variable that stores a file path like this
fileLoc = "C:\Here\There\myFile.xls"
Now what splitting or anything I need to do to parse out the file name out of that string and retrun me only string without the filename like this
filLoc now becomes "C:\Here\There"
what to do in VBA? if I want the strign like this from a full file path...