How to extract the path infor

[Guest]

I have a String variable folder, whose value could be "D:level1level2..sth"
I need to extract the "sth", how could i realise this? length of "sth" is not fixed.
Thx.

 

[Dave Hawley]

Hi

These things are generally easier if you do them first on a Worksheet, then adapt to VBA..

=MID(A1,SEARCH("\st*",A1)+2,LEN(A1))

Works on a Worksheet, so..

Dim strFile As String
strFile = "D:\level1\level2\..\sth"
strFile = _
Mid(strFile, WorksheetFunction.Search("\st*", strFile) + 2, Len(strFile))
MsgBox strFile

Will work in VBA. Of course you should be aware that it will get in wrong if there is a directory before/after it like "\sh*"

 

[Dave Hawley]

This time witout HTML enabled )

=MID(A1,SEARCH("\st*",A1)+2,LEN(A1))

Works on a Worksheet, so..

Dim strFile As String
strFile = "D:\level1\level2\..\sth"
strFile = _
Mid(strFile, WorksheetFunction.Search("\st*", strFile) + 2, Len(strFile))
MsgBox strFile

Will work in VBA. Of course you should be aware that it will get in wrong if there is a directory before/after it like "\sh*"


_________________
Kind Regards
Dave Hawley
OzGrid Business Applications
Microsoft Excel/VBA Training
If it's Excel, then it's us!
This message was edited by Dave Hawley on 2002-03-06 21:31

 

[Guest]

Sorry,i am not so clear about your codes:
Dim strFile As String
strFile = "D:\\level1\\level2\\..\\sth"
strFile = _
Mid(strFile, WorksheetFunction.Search("\\st*", strFile) + 2, Len(strFile))
MsgBox strFile

How come so many ""?
I need to extract the string after last ""?
Is this possible using simple codes?
Please enlighten.

 

[Guest]

alternatively, could you tell me how to find the last "" in a string which is a path.

 

[Dave Hawley]

Ignore the extra back slashes they just happen when you post the comment.