find and replace text

[Guest]

if i have a image that is located at a location like this
http://www.website.com/site/images.products/2/PSproduct_pics/delonghi/DTT900.jpg
i just want DTT900.jpg

but the same find and replace has to work for something like this:
http://www.doba.com/site/images.products/2/dl_pics/1/160.jpg
and return 160.jpg

so basically i need it to find the last "/" then return anything after that.

Thanks in advance

 

[Steve Yandl]

After you get your hyperlink as text, you can use something like:

strHTTP =
"http://www.website.com/site/images.products/2/PSproduct_pics/delonghi/DTT900.jpg"

arrPath = Split(strHTTP, "/")
strImageName = arrPath(UBound(arrPath))

MsgBox strImageName


Steve