Sub test()
Dim namae(900), kazu(900)
Set xmlhttp = CreateObject("Msxml2.xmlhttp")
basyo0 = "ここに url (mid= まで) を貼り付け"
dokomade = 何番目の投稿までカウントするか
ninzuu = 0
hazime = 1
If Range("C1") <> "" Then
owari = Range("C1")
If owari >= dokomade Then Exit Sub
hazime = owari + 1
Do While Cells(ninzuu + 1, 1) <> ""
ninzuu = ninzuu + 1
namae(ninzuu) = Cells(ninzuu, 1)
kazu(ninzuu) = Cells(ninzuu, 2)
Loop
End If
nai = 0
For i = hazime To dokomade
basyo = basyo0 & i
xmlhttp.Open "GET", basyo, False
xmlhttp.send
nakami = xmlhttp.responseText
j0 = InStr(nakami, "")
If j0 = 0 Then
If nai > 5 Then Exit For
nai = nai + 1
Else
nai = 0
owari = i
j1 = InStr(j0, nakami, "")
namae1 = Mid(nakami, j1 + 16, j2 - j1 - 16)
iru = 0
j = 0
Do While j <ninzuu And iru = 0
If namae(j) = namae1 Then
kazu(j) = kazu(j) + 1
iru = 1
End If
Loop
If iru = 0 Then
ninzuu = ninzuu + 1
namae(ninzuu) = namae1
kazu(ninzuu) = 1
End If
End If
Next
Set xmlhttp = Nothing
If owari >= hazime Then
Range("C1") = owari
For i = 1 To ninzuu
Cells(i, 1) = namae(i)
Cells(i, 2) = kazu(i)
Next
End If
End Sub