vendredi 24 novembre 2017

VBA Complex Web Scrapping

Can someone help to achieve my goal of getting the value of a span inside multiple element tags?

Here's an example, I am trying to automate the pulling of data from a website and put in an excel row.

<html>
<body class="bodyclass">
<div class="div1class">
<iframe id="iframe1">
<html>
<body class="body2">
<section id="section1">
<div class="div2">
<table class="table1">
<tbody>
<tr class="tr1">
<td class="aa bb cc">
<span class="span1">ABCD>/span>

I already tried to use getElementsByClassName("span1")(0) but it still didn't get the value "ABCD".




Aucun commentaire:

Enregistrer un commentaire