InStrRev

[mAP3d]

Hi guys,

I am working on excel 2010 and have a file path from which I need to separate the file name. Since the files could always be in different places, I wanted to search for the last "\" with InStrRev. Then I wanted to subtract this value from the length (Len) of the string and use this value with "Right()" to cut of only the file name. My problem is, that InStrRev just doesn't show a value.

Right(strListe, Len(strListe) - InStrRev(strListe, "\"))

The file path is stored in "strListe", its only InStrRev which doesn't do his job.

Someone got an idea?

btw it worked with InStr but I can not use this value.

 

[Norie]

Don't know if this is worth knowing but if you use Dir with the full path and filename it only returns the filename, so kind of no need to use InstrRev or any other text parsing.