Hello everyone

In my case, I have a HTML local file which has a table. Here's a link of the contents of HTML http://try.jsoup.org/~LsArJXLumBWg2HOgluVzOXm9bRs When manually using this selector table[width='100%'] table:first-child I could get results with no problem at all. In my excel VBA code, I got these two lines
Set tables = html.querySelectorAll("table[width='100%'] table:first-child")
For i = 89 To tables.Length - 17 Step 26
Now I got an error Invalid use of NULL at this line For i = 89 To tables.Length - 17 Step 26 and I have used the immediate window to see tables.Length and I got NULL. The code was working before without any problem but now it throws this error. I have inspected the local window and found that the tables is an object like that

LA1Tr.png

But when trying to expand the variable in the immediate window, excel hangs and exits.

This is how I deal with the local html file
With fStream
    .Charset = "UTF-8"
    .Open
    .LoadFromFile sFolder & sFile
    html.body.innerHTML = .ReadText
    .Close
End With
sStatus = vbNullString
sStatus = Application.Trim(Replace(Split(sFile, "-")(2), ".html", ""))
Set tables = html.querySelectorAll("table[width='100%'] table:first-child")
For i = 89 To tables.Length - 17 Step 26