Why VBA cannot read HTML content?

I am trying to read html content by VBA without opening browser. Unfortunately, one of the most popular solutions in the internet which is below, does not work...

Dim oDom As Object: Set oDom = CreateObject("htmlFile")
   
With CreateObject("msxml2.xmlhttp")
    .Open "GET", "https://mystoreuat.rbhconnect.ca/internal/store/store-details/11253", False
    .send
    oDom.body.innerHTML = .responseText
End With

tt = oDom.body.innerHTML 
Cells(1,1).Value = tt

As a result I receiving just a few lines of code like meta tags and so one, but nothing important from body

<!DOCTYPE html>
<html lang="en" ng-app="public">
<head>
    <base href="/home/">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta content="width=device-width,initial-scale=1" name="viewport">
    <meta charset="utf-8" >
    <title>MyStore</title>
    <link href="https://fonts.googleapis.com/css?family=Oswald:300,400,500,600,700&amp;subset=latin-ext" rel="stylesheet">
    <link href="https://fonts.googleapis.com/css?family=Roboto:300,300i,400,400i,500,700,900&amp;subset=latin-ext" rel="stylesheet">
    <link href="https://fonts.googleapis.com/css?family=Roboto+Condensed:300,400,700&amp;subset=latin-ext" rel="stylesheet">
    <link href="https://fonts.googleapis.com/css?family=Roboto+Mono:300,400,500,700&amp;subset=latin-ext" rel="stylesheet">
    <link href="https://fonts.googleapis.com/css?family=Roboto+Slab:300,400,700" rel="stylesheet">
    <link rel="shortcut icon" href="/favicon.ico?v=1" type="image/x-icon">
    <link rel="icon" href="/favicon.ico?v=1" type="image/x-icon">
    <link rel="stylesheet" href="/styles/main-421f3236.css">
</head>

<body class="has-footer {{bodyClass}}">
    <test-system-message></test-system-message>

    <div ui-view></div>

    <flagship-footer></flagship-footer>
    <cookie-policy-popup></cookie-policy-popup>
    

  <script src="/scripts/vendor-ceeaf1a7.js"></script>
  <script src="/scripts/main-b1b8a76b.js"></script>
</body>
</html>

Is there any other way to get information from website without opening broswer?

Why VBA cannot read HTML content?

0 Answers