String Manipulation

[Loggerhead2000]

Hi, I'm tring to just get a file name from a file path
I have this C:\Windows\folders\file.txt,want to Get this File.txt

I think this is posible but not sure how to do any suggestions would be great, thanks Timmeh

 

[Hypetia]

FileName = Dir(FilePath)
-OR-
Dim V As Variant
V = Split(FilePath, "\&quot
FileName = V(UBound(V))

 

[vb5prgrmr]

Try this...
[tt]
Dim S As String
S = "C:\Windows\folders\file.txt"
S = Mid(S, InStrRev(S, "\&quot + 1)
Debug.Print S
[/tt]

Good Luck

 

[johnwm]

Did you check the FAQ section before asking?

Try faq222-3420


________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'People who live in windowed environments shouldn't cast pointers.'