I hope it will be useful to someone somehow(i found it practical). It gets the specific part in a text between the begining and the ending strings;
VB Code:
'In a module type the following: Function Between(Begining As String, Ending As String, TextToLookIn As String) Dim Be As String, En As String, TTLI As String Be = Begining En = Ending TTLI = TextToLookIn TTLI = Right(TTLI, Len(TTLI) - (InStr(1, TTLI, Be) + Len(Be) - 1)) TTLI = Left(TTLI, InStr(1, TTLI, En) - 1) Between = TTLI End Function
Hope it will be useful. If u think its not useful plz pm me.![]()




Reply With Quote