
a = "http://xxx.xxx.com/jy_website/mlrs000/Index.html"MsgBox Mid(a, InStr(a, "/jy_website/") + 12, InStr(InStr(a, "/jy_website/") + 12, a, "/") - InStr(a, "/jy_website/") - 12)

a = "http://xxx.xxx.com/jy_website/mlrs000/Index.html"MsgBox Mid(a, InStr(a, "/jy_website/") + 12, InStr(InStr(a, "/jy_website/") + 12, a, "/") - InStr(a, "/jy_website/") - 12)