Public Function fParseXML(sTag01 As String, sTag02 As String, sToParse As String) As String Dim pStart As Integer Dim pEnd As Integer Dim pLen As Integer If InStr(1, sToParse, sTag01) Then pStart = InStr(1, sToParse, sTag01) + Len(sTag01) pEnd = InStr(pStart, sToParse, sTag02) pLen = pEnd - pStart fParseXML = Mid(sToParse, pStart, pLen) Exit Function Else fParseXML = "Not found" & "**" & sTag01 & "**" & Mid(sToParse, 1, 100) Exit Function End If End Function 'Usage: Sub TestIt() ' "F) GND G) FL240)" MsgBox "**" + fParseXML("F)", "G)", "F) GND G) FL240)") + "**" MsgBox "**" + fParseXML("G)", ")", "F) GND G) FL240)") + "**" End Sub |