getElementsByTagName() question

[conception_native_0123]

I am scraping a web page and I'm missing a method. can someone help me out? this page spells it out but VBA puts a semicolon in the code when I try it:

W3Schools.com

W3Schools offers free online tutorials, references and exercises in all the major languages of the web. Covering popular subjects like HTML, CSS, JavaScript, Python, SQL, Java, and many, many more.

www.w3schools.com

the code I have is:

Dim ie As InternetExplorer, counter As Long, length As Long
Set ie = New InternetExplorer

ie.Visible = True
ie.navigate "https://www.fairhopeartsandcraftsfestival.com/artists/jewelry"

    While ie.Busy
        DoEvents
    Wend

        length = ie.Document.getElementsByTagName("a").length
        counter = ie.Document.getElementsByTagName("a").length
            Debug.Print ie.Document.getElementsByTagName("a")[0].innerHTML

but the code's last line is read by VBA like this:

Debug.Print ie.Document.getElementsByTagName("a"); [0].innerHTML

can someone give me a push here? I'm not ready to transition to the chromium model yet. thanks.

 

[The_Doc_Man]

I believe the correct syntax for what you are doing is to place the 0 in () rather than []. According to the documentation for subroutine getElementsByTagName, your return value is an array of elements, and VBA's syntax to index an array is ( n ), not [n].

EDIT: And somehow, the "thumbs down" emoji is left-parenthesis, 0, right-parenthesis. Which was NOT what I intended.

With that square bracketing, I've got NO idea as to what Access thinks that [0] is, but it knows it doesn't belong to the array. To say that it reads the line as though the semicolon is there is to say that the parser does not see the [0] as a legal part of the complex reference - so it breaks at that point. Then, of course, I have no clue why it didn't break with a compile error there either, unless there IS an object named [0] somewhere in scope.

 

[conception_native_0123]

thanks doc.. this works just fine:

Debug.Print ie.Document.getElementsByTagName("a")(0)

not sure why I didn't try it to begin with. :/