Leung,
Look into InStrRev or Split functions.

NickHK

"Leung" wrote in message
...
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