ShortFileName = Right(LongFileName,Len(LongFileName) - _
InStrSev(LongFileName, Application.PathSeparator))

HTH

Charles Chickering
Ski wrote:
I have a file name that includes the entire file path, file name, and
extension:

C:\Documents and Settings\Desktop\Master Schedules\Overall IMS -
26May2006.mpp

I need some code to shorten that to just:

Overall IMS - 26May2006.mpp

I can't just type it in because the file is different each time, based
on user input.

Thanks in advance