Hi asd987
Try this:
'snip from
'Ole Sørensen 20040430
Dim sTmp As String
sTmp = "C:\Dokumenter og test\jbotester\test1\test2\testigenigenigen3.xls"
' Split path
Dim sTemp() As String
sTemp() = Split(sTmp, "\")
' Count number of elements in sTemp()
Dim nAntalElementer As Integer
nAntalElementer = 0
Dim vElement As Variant
For Each vElement In sTemp
nAntalElementer = nAntalElementer + 1
Next
'here you are
MsgBox sTemp(nAntalElementer - 1)
Best regards from
Jørgen Bondesen
"Anton" <anton_dk@hotmail.com> wrote in message
news:40963e25$0$254$edfadb0f@dread11.news.tele.dk...
> Try to look at Split()
> /AV
> "asd987" <asd987@home.nl> skrev i en meddelelse
> news:c759rh$i9p$1@news5.tilbu1.nb.home.nl...
> > Hi,
> >
> > Is it possible to find a certain part in a string? I need the last part
> of
> > the string which is after the last backslash in the string. The string
can
> > contain more than one backslah but i never know how much.
> >
> > Example:
> >
> > f:\Dir1\Dir2\Dir3\Filename.Ext.
> > What I need is Filename.Ext
> >
> > Thanks.
> >
> >
>
>