Excel - VBA: Object variable or With block variable not set

Asked Oct 04 '22 at 15:57

Active Oct 04 '22 at 15:57

Viewed 99 times

I'm trying to automate some commands by getting some values from the web page, but this error appears and I don't know what it should be

Sub Test()
Dim IE As New InternetExplorerMedium

IE.Visible = False
IE.navigate "http://..."
Do
Loop Until Not (IE.Busy)


Cells(4, 2) = IE.document.getElementsByClassName("style363")(0).innerText

Stop
End Sub

asked Oct 04 '22 at 15:57

Matheus Vinicius

1

you do not `Set` `IE` to any thing. – Scott Craner Oct 04 '22 at 16:04
@ScottCraner but it's `Dim`med `As New` (which is still a [bad idea](https://stackoverflow.com/questions/42656468/whats-the-difference-between-dim-as-new-vs-dim-set)) – BigBen Oct 04 '22 at 16:43
Possibly the document is not yet fully populated, or it is complete but there are no elements with that class name. – Tim Williams Oct 04 '22 at 17:25
@TimWilliams it's not that, i tried to change it to "Tag Name" and didn't run too – Matheus Vinicius Oct 04 '22 at 17:34
Without a URL or the relevant source HTML it's difficult to suggest anything. – Tim Williams Oct 04 '22 at 17:35
@TimWilliams it's because it's a private domain, the error is not related to the HTML address – Matheus Vinicius Oct 04 '22 at 17:46
You will get that error if `IE.document.getElementsByClassName("style363")(0)` is `Nothing`. Put a breakpoint on that line and then check if it evaluates to an object by typing `?IE.document.getElementsByClassName("style363")(0)` in Immediate window. – Siddharth Rout Oct 04 '22 at 17:48

Excel - VBA: Object variable or With block variable not set

0 Answers0