It was a simple code that extracts in column A the element's name, in column B the elements id's ,in column C ???, in column D the inner text.
If i remember correctly there were 4 columns used, 4 pieces of info were extracted.
Can someone provide or create something similar?
The code was similar with the below:
- Code: Select all
Sub GetAllTables(D)
For Each E In D.all
If E.nodename = "TABLE" Then
Set t = E
tabno = tabno + 1
nextrow = nextrow + 1
Set Rng = Range("B" & nextrow)
Rng.Offset(, -1) = "Table " & tabno
For Each r In t.Rows
For Each c In r.Cells
Rng.Value = c.innerHTML
Set Rng = Rng.Offset(, 1)
I = I + 1
Next c
nextrow = nextrow + 1
Set Rng = Rng.Offset(1, -I)
I = 0
Next r
End If
Next E
End Sub