Hi, I need help with adjusting the macro to the website: https://euroesi.mazda.co.jp/esicont/eu_eng/mazda6/20120903161818/html/id0102h4801500.html .
I am using the code "ByClassName" ,but I cannot get the title "DTC TABLE[SKY..." to the excel spreadsheed from this service page, after my attempts it loaded wrong data or didn't load any. I am enclosing the code below.
Sub url_test2()
Dim act_name As String
Dim request As Object
Dim response As String
Dim html As New HTMLDocument
Dim title As Variant
act_name =
"https://euroesi.mazda.co.jp/esicont/eu_eng/mazda6/20120903161818/html/id0102h4801500.html"
Set request = CreateObject("MSXML2.XMLHTTP")
request.Open "GET", act_name, False
request.send
response = StrConv(request.responseBody, vbUnicode)
html.body.innerHTML = response
title = html.getElementsByClassName
End Sub("servinfo-head")