find the file

[Keltoi]

Hi, quick an simple (I think).

I need to print the file name only from a string like the following:
C:\directory\some\dir\myfile.txt
so that only "myfile.txt" (or whatever) is printed.

Any ideas?

Thanks

Justin

[oracleguy]

Dim strMyString, strNewString

strMyString = "C:\directory\some\dir\myfile.txt"

strNewString = Mid(strMyString, InStrRev(strMyString, "\") + 1)

That should do it.

[Keltoi]

works a treat :D thanks oracleguy:thumbsup: