Hi All, Can any one help in this vba code. I need to pull <div class codes which are highlighted in yellow color in the Html code to excel file. The out put that is need is listed below.
The out put that i need should be like below table.
Thanks for you help,
Rsha
Code:
Sub GetDat()
Dim IE As New InternetExplorer, html As HTMLDocument
Dim elem As Object, data As String
With IE
.Visible = True
.navigate "https://MYURL/sc/wo/WO/index?id=76888564"
Do While .readyState <> READYSTATE_COMPLETE: Loop
Set html = .document
End With
data = ""
For Each elem In html.getElementsByClassName("simple-list")(0).getElementsByTagName("li")
data = data & " " & elem.innerText
Next elem
Range("A1").Value = data
IE.Quit
End Sub
The out put that i need should be like below table.
Date | Feedback |
3 Dec 13 2016 23:30 CST | At this time the work order has been updated to a billable status. Your company can process an invoice against the work order. For any questions regarding invoicing, refer to the Invoice instructions on the Help Link in |
2 Dec 11 2016 02:15q | Status changed by auto-update procedure. |
1 Dec 01 2016 01:51 CST | Auto Dispatch summary sent to divisionsinc.com on Dec 01, 2016 02:50 EST |
Thanks for you help,
Rsha