Accessing an input element embeded in an HTML table through VBA

Question

I've looked around and I'm not sure this question has been asked before. I think I'm onto the beginning of a solution but here is my issue. I have an HTML table on a web page that has an input element built into it and I need to access it through VBA. Here is the relevant snippet of the HTML:

I can find this cell easily enough using the following code:

Set Cells = HTMLDoc.getElementsByTagName("td")
For Each Cell In Cells
    If Cell.className = "tbl1" And Cell.something = something Then
        'This is the cell
    End If
Next Cell

There are only 5 cells on the page, so no big deal. What I still need to do is to figure out how to use the input element. I guess through get child or something? Can't seem to find any leads on that...

Blackhawk · Accepted Answer · 2013-11-07 23:01:39Z

1

Try InvokeMember:

Set Cells = HTMLDoc.getElementsByTagName("td")
For Each Cell In Cells
    If Cell.className = "tbl1" And Cell.something = something Then
        Cell.InvokeMember("click")
    End If
Next Cell

answered Nov 7, 2013 at 23:01

Blackhawk

6,1804 gold badges31 silver badges60 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Accessing an input element embeded in an HTML table through VBA

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related