title: Scrape website that has endless scrolling in VBA
body: <p>I have encountered a website that has an endless scroll when navigating to the website. That means when you manually scroll down and without any clicks the web page is loading automatically ..
  This is my try</p>
  <pre><code>Sub Test()
      With CreateObject(&quot;InternetExplorer.Application&quot;)
          .Visible = True
          .Navigate &quot;https://shopee.com.my/shop/145423/followers/?__classic__=1&quot;
          Do: DoEvents: Loop While .Busy Or .readyState &lt;&gt; 4
          Dim html As Object
          Set html = .document
          Dim elemRect As IHTMLRect: Set elemRect = html.querySelector(&quot;.loading-text&quot;) 'myDiv.getBoundingClientRect
      Do Until elemRect.bottom &gt; 0
          .ParentWindow.scrollBy 0, 10000
          Set elemRect = html.querySelector(&quot;.loading-text&quot;)
      Loop
      End With
  End Sub
  </code></pre>
  <p>I need to know if it is possible to scrape such webpages and if yes how can this process be controlled?</p>