VBA error when pulling data from table

[bensdb]

I'm trying to pull some sales data from a table on a website....

Seem to be stuck, getting "error 70 permission denied"..Is my code correct?

Here is a snippet...everything up to this point is OK...I think it is the "innertext" line that might be erroneous.

Set html = ie.Document    
    Set tablediv = html.getElementById("reportData")
    Set trs = tablediv.getElementsByTagName("tr")
    For Each tr In trs
        Set tds = tr.getElementsByTagName("td")
        rownum = rownum + 1


        For Each td In tds
            cellnum = cellnum + 1
            If Not td Is Nothing Then
                ws2.Cells(rownum + LastRow, cellnum).Value = td.innerText
            End If
        Next
    Next

I've got the relevant references included.

Basically I'm parsing through a table and adding the data to my worksheet.

Thanks for your help!

 

[baitmaster]

How good are you at debugging - do you use the immediate window and/or the watch window?

- Using Watch window: When your code breaks, what is the value for td? or td.innertext?
- Using Immediate window, manually: when code breaks, type "?td.innertext" and hit enter, what happens?
- Using Immediate window automatically, add code line debug.print td.innertext after your IF line and before your innertext line. What is showing in the Immediate window when your code breaks? Or does it break on this new line?