VBA WebScraping "object variable or with block variable not set" error

Question

I keep getting "object variable or with block variable not set" error when running the below VBA. All i am trying to do is return a = html.getElementById("") but keep getting an error on that line. I have removed everything between "" as they are sensitive details.. Cheers in advance

Sub web_scrape()

Dim IEobject As InternetExplorer
Dim a As Variant
Set IEobject = New InternetExplorer

IEobject.Visible = True
IEobject.navigate Url:=("website.url")
Do While IEobject.Busy = True Or IEobject.readyState <> READYSTATE_COMPLETE

      Application.Wait Now + TimeValue("00:00:01")
      Loop

Dim html As HTMLDocument
Set html = IEobject.document

html.getElementById("AuthUC$txtUserID").Value = ("")
html.getElementById("AuthUC_txtData").Value = ("")
html.getElementById("AuthUC_btnLogin").Click

a = html.getElementById("")


End Sub

CM2020 · Accepted Answer · 2020-07-22 14:02:54Z

1

Is it perhaps as simple as adding a 'set'?

set a = html.getElementById("")

answered Jul 22, 2020 at 14:02

CM2020

781 silver badge7 bronze badges

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

Collectives™ on Stack Overflow

VBA WebScraping "object variable or with block variable not set" error

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