Actually I had a quick peek and you are in luck. Turns out I still have a replace function I wrote about 12 years ago in VB5
Code:Public Function ReplaceMe(Source As String, Target As String, Replacement As String) As String Dim Startpos As Integer Dim Ltemp As String Dim Rtemp As String Startpos = InStr(Source, Target) Do While Startpos > 0 Ltemp = Left$(Source, Startpos - 1) If Len(Source) - (Startpos + Len(Target)) > 0 Then Rtemp = Right$(Source, Len(Source) - (Startpos + Len(Target))) Else Rtemp = "" End If Source = Ltemp + Replacement + Rtemp Startpos = InStr(Source, Target) Loop ReplaceMe = Source End Function




Reply With Quote