dhighto
03-05-2015, 06:24 AM
Hey guys,
I'm pulling data from a web page to store into Excel. I have no problem when the data has labeled with an id, but I can't figure out code like <span title="dod" class="data">. Can anyone help a vba newbie? This is the code I'm looking at. I'm trying to pull the the DOD data (02/02/2015). I think I would use getattribute, but I'm not the greatest at writing code.
<ulclass="dod">
<li>Name: <spanclass="data"title="name"><ahref="#"class="combolink"id="comboname1_4"xxxxxxxxxxx</a></span></li>
<li>DOD: <spanclass="data"title="dod">02/02/2015</span>, Died at <spanclass="data">51</span></li>
</ul>
Thanks,
I'm pulling data from a web page to store into Excel. I have no problem when the data has labeled with an id, but I can't figure out code like <span title="dod" class="data">. Can anyone help a vba newbie? This is the code I'm looking at. I'm trying to pull the the DOD data (02/02/2015). I think I would use getattribute, but I'm not the greatest at writing code.
<ulclass="dod">
<li>Name: <spanclass="data"title="name"><ahref="#"class="combolink"id="comboname1_4"xxxxxxxxxxx</a></span></li>
<li>DOD: <spanclass="data"title="dod">02/02/2015</span>, Died at <spanclass="data">51</span></li>
</ul>
Thanks,