Web Automation using Excel VBA

Question

I tried to automate some logins and copy paste from the web onto my own machine. When I try the same thing from company's intranet I face problems. My error message is:

Object variable or With block variable not set.

Here is my code:

Sub getdata()
Dim IE As Object
Dim Doc As HTMLDocument
Dim naziv, test, test2 As Variant

'Set IE = CreateObject("InternetExplorer.Application")
Set IE = New InternetExplorerMedium

IE.Visible = True

IE.navigate "https://example.com/Pages/default.aspx"

Do While IE.readyState = 4
DoEvents
Loop

Set test = Doc
Set test2 = Doc

test2 = test.getElementById("testid")

MsgBox (test2.innerText)

End Sub

You have not initialized your Doc variable.

Brian M Stafford
– Brian M Stafford

2017-06-02 14:34:08 +00:00
Commented Jun 2, 2017 at 14:34 — Brian M Stafford
– Brian M Stafford, Commented Jun 2, 2017 at 14:34

Subodh Tiwari sktneer · Accepted Answer · 2017-06-02 15:54:14Z

3

Remove the following two lines

Set test = Doc
Set test2 = Doc

Set the doc variable first

Set Doc = IE.document

and then set the test2 object

set test2 = Doc.getElementById("testid")

edited Jun 2, 2017 at 15:54

answered Jun 2, 2017 at 14:35

Subodh Tiwari sktneer

9,9862 gold badges20 silver badges22 bronze badges

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

5 Comments

Siddharth Rout Over a year ago

'--> Set test2 = Doc.getElementById("testid") :)

Subodh Tiwari sktneer Over a year ago

@SiddharthRout Thanks for the correction. I forgot to add that. :)

Siddharth Rout Over a year ago

++ no worries, I also miss small things sometime :)

Subodh Tiwari sktneer Over a year ago

Thanks once again. :)

Bence Over a year ago

Thank you very much for your quick help, now I am getting another error message: Method 'Document' of object 'IWebBrowser2' failed. I cannot imagine how can I solve that, I am trying it 1 week ago...thank you if you cam add some concerns :).

Collectives™ on Stack Overflow

Web Automation using Excel VBA

1 Answer 1

5 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Related