Private Function RecuperarValor( _
ByVal Cadena As String, _
ByVal PalabraABuscar As String) As String
Dim lng1 As Long
lng1 = InStr(1, Cadena, PalabraABuscar)
If lng1 = 0 Then
MsgBox "'" & PalabraABuscar & "'" & vbCrLf _
& "No se pudo localizar el texto" _
, vbExclamation, "Buscar"
Exit Function
End If
lng1 = lng1 + Len(PalabraABuscar)
If lng1 < Len(Cadena) Then
lng1 = InStr(1, Cadena, Chr(32))
If lng1 = 0 Then Exit Function
Else
Exit Function
End If
Cadena = LTrim(Mid(Cadena, lng1))
lng1 = InStr(lng1, Cadena, Chr(32))
If lng1 > 0 Then Cadena = Left(Cadena, lng1)
RecuperarValor = RTrim(Cadena)
End Function