Want to extract text without class or element tags from a website into excel with VBA

Try something like this.

    strBoyGirl = IE.Document.getElementsByTagName("b").Item(1).innerText
    strCommon = IE.Document.getElementsByTagName("b").Item(2).innerText