[RESOLVED] getting filename from a sitename

[Pouncer]

e.g.

http://www.mysite.com/hello/hi/anotherfolder/test.jpg would give me test.jpg

http://www.my.site.com/test2/jpg would give me test2.jpg

etc

any ideas guys?

[Hack]

Private Sub Command1_Click()
Dim strURL As String
Dim arrFileName() As String
strURL = "http://www.mysite.com/hello/hi/anotherfolder/test.jpg"
arrFileName = Split(strURL, "/")
MsgBox arrFileName(UBound(arrFileName))
End Sub