Descarga la página html en una variable, busca la cadena "sb-offers-table-interest" dentro y justo detrás está el %. Es cuestión de ir repitiendo las búsquedas.
-----------------------------------
Private Declare Function InternetOpen Lib "wininet.dll" Alias "InternetOpenA" (ByVal sAgent As String, ByVal lAccessType As Long, ByVal sProxyName As String, ByVal sProxyBypass As String, ByVal lFlags As Long) As Long
Private Declare Function InternetOpenUrl Lib "wininet.dll" Alias "InternetOpenUrlA" (ByVal hInternetSession As Long, ByVal sURL As String, ByVal sHeaders As String, ByVal lHeadersLength As Long, ByVal lFlags As Long, ByVal lContext As Long) As Long
Private Declare Function InternetReadFile Lib "wininet.dll" (ByVal hFile As Long, ByVal sBuffer As String, ByVal lNumBytesToRead As Long, lNumberOfBytesRead As Long) As Integer
Private Declare Function InternetCloseHandle Lib "wininet.dll" (ByVal hInet As Long) As Integer
Private Const IF_FROM_CACHE = &H1000000
Private Const IF_MAKE_PERSISTENT = &H2000000
Private Const IF_NO_CACHE_WRITE = &H4000000
Private Const BUFFER_LEN = 256
Private Sub Form_Activate()
Dim c As String
ruta = App.Path: If Len(ruta) > 3 Then ruta = ruta & "\"
ru = ruta & "salida.txt"
Open ru For Output As 1
c = "
https://www.raisin.es/bancos/haitong-bank/": GoSub lee
c = "
https://www.raisin.es/bancos/banca-progetto/": GoSub lee
c = "
https://www.raisin.es/bancos/privatbanka/": GoSub lee
c = "
https://www.raisin.es/bancos/banca-sistema/": GoSub lee
c = "
https://www.raisin.es/bancos/ckv-bank/": GoSub lee
c = "
https://www.raisin.es/bancos/banca-promos/": GoSub lee
c = "
https://www.raisin.es/bancos/fjord-bank/": GoSub lee
c = "
https://www.raisin.es/bancos/banca-privata-leasing/": GoSub lee
c = "
https://www.raisin.es/bancos/jt-banka/": GoSub lee
c = "
https://www.raisin.es/bancos/klarna-bank/": GoSub lee
c = "
https://www.raisin.es/bancos/coop-pank/": GoSub lee
c = "
https://www.raisin.es/bancos/younited/": GoSub lee
c = "
https://www.raisin.es/bancos/blueorange-bank/": GoSub lee
c = "
https://www.raisin.es/bancos/alior-bank/": GoSub lee
c = "
https://www.raisin.es/bancos/as-lhv-pank/": GoSub lee
c = "
https://www.raisin.es/bancos/bacb/": GoSub lee
c = "
https://www.raisin.es/bancos/euram-bank/": GoSub lee
c = "
https://www.raisin.es/bancos/siauliu-bankas/": GoSub lee
c = "
https://www.raisin.es/bancos/brabank/": GoSub lee
Close
Shell ruta & "compa.bat", vbNormalFocus
GoTo sale
'----------------------------
lee:
cad = LeeURL(c): p = "": w = 1
otro:
DoEvents: q = InStr(w, cad, "sb-offers-table-interest"): If q = 0 Then GoTo lee2
p = p & " " & Mid(cad, q + 26, 4): w = q + 30: GoTo otro
lee2:
p = c & p: List1.AddItem p: Print #1, p: Return
'---------------------------------
sale:
List1.AddItem "Fin."
End Sub
Function LeeURL(sURL As String) As String
Dim sBuffer As String * BUFFER_LEN, iResult As Integer, sData As String
Dim hInternet As Long, hSession As Long, lReturn As Long
'get the handle of the current internet connection
hSession = InternetOpen("vb wininet", 1, vbNullString, vbNullString, 0)
'get the handle of the url
If hSession Then hInternet = InternetOpenUrl(hSession, sURL, vbNullString, 0, IF_NO_CACHE_WRITE, 0)
'if we have the handle, then start reading the web page
If hInternet Then
'get the first chunk & buffer it.
iResult = InternetReadFile(hInternet, sBuffer, BUFFER_LEN, lReturn)
sData = sBuffer
'if there’s more data then keep reading it into the buffer
Do While lReturn <> 0
DoEvents
iResult = InternetReadFile(hInternet, sBuffer, BUFFER_LEN, lReturn)
sData = sData + Mid(sBuffer, 1, lReturn)
Loop
End If
'close the URL
iResult = InternetCloseHandle(hInternet)
LeeURL = sData
End Function