A
Arawn
I have a part of a macro that I need some help with.
I have the code that is returning the full file path, and then the
full file path with the filename, but I want to simply return the
filename for use in other coding.
Basically what I want is:
File_Name = (Full_Path_with_File_Name - Full Path)
However, I dont know how to go about this. Both the file name and
pathing will be variable, with varying lengths and names.
I'm using Excel 2003, if that makes a difference.
Thanks,
~Arawn
I have the code that is returning the full file path, and then the
full file path with the filename, but I want to simply return the
filename for use in other coding.
Basically what I want is:
File_Name = (Full_Path_with_File_Name - Full Path)
However, I dont know how to go about this. Both the file name and
pathing will be variable, with varying lengths and names.
I'm using Excel 2003, if that makes a difference.
Thanks,
~Arawn