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