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
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![]()
Please Login or Register to view this content.
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
![]()
Please Login or Register to view this content.
Bookmarks