Hi

Is there anyway use some text extract function in VBA so that I can retrieve
the file name from these path? How to write a code in a function to retrieve
the name:

such as intri function??
path:
F:\FC_bank\_common\Month-end Jun 05\MEJun2005\SAP\RC code 13Jul2005.xls
string to retrieve:
RC code 13Jul2005.xls

thanks

Leung