Extract element from html document with vba excel

Question

I have this code below from HTML document, result of inspection object from site web.
I want to get the object <input name="username" value=""> with VBA Excel code.

<tr id="username_block"> 
    <td class="shade" width="50%" align="right"> 
        <div align="left">Nom d’utilisateur:</div>
    </td>
    <td class="shade" width="50%"> 
        <input name="username" value="">
    </td>
</tr>

I use this instruction

set element=oIe.Document.getElementsById("username_block")

but no results (element=nothing).

Can you expand on your code? What is ole and where is it defined? — NickSlash
– NickSlash, Commented Dec 27, 2022 at 10:54

Claudio · Accepted Answer · 2022-12-27 15:46:30Z

2

Isn't the method's name getElementById, without "s"?

answered Dec 27, 2022 at 15:46

Claudio

759 bronze badges

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

1 Comment

F. Müller Over a year ago

It is. And this is most probably the issue here. Well spotted. :)

Collectives™ on Stack Overflow

Extract element from html document with vba excel

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related