Data Scrape from IE

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.

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 don't know if it's the "right" way but I would do:

DOD = left(Split(IEData,"title=""dod"">")(1),10)

obviously replace IEData with the variable you have the page data in.

Quote:

---

Originally Posted by Blade Hunter

I don't know if it's the "right" way but I would do:

DOD = left(Split(IEData,"title=""dod"">")(1),10)

obviously replace IEData with the variable you have the page data in.

---

I'm still confused. Is this the code you would use? What would DOD be declared as? An HTMLformelement?

Code:

---

DOD = left(Split(IEData,"title=""dod"">")(1),10)
Range("E" & irow) = IE.Document.getattribute("DOD").innerText

---

Thanks,

DOD is just a string variable I am using in the example to store the results of the string manipulation.

Quote:

---

Originally Posted by dhighto

I'm still confused. Is this the code you would use? What would DOD be declared as? An HTMLformelement?

Code:

---

DOD = left(Split(IEData,"title=""dod"">")(1),10)
Range("E" & irow) = IE.Document.getattribute("DOD").innerText

---

Thanks,

---