Hi,
I'm pretty newbie in excel vba. I have this problem:
I want excel to check the availability of an item @ BGS technic
for instance "1195"
I wrote this vba:
My problem is, that I only need the part "Item in in stock, more than 50 pcs. available" to be showed/ inserted in excel, but i don't manage to get it, as it has no separate ID.
<thead>
</thead><tbody>
</tbody>
Could anybody help me please?
I'm pretty newbie in excel vba. I have this problem:
I want excel to check the availability of an item @ BGS technic
for instance "1195"
I wrote this vba:
Code:
Sub ImportMyData()
Dim IE As New InternetExplorer
IE.Visible = False
IE.navigate "http://www.bgstechnic.com/availability?processed&F1244467957750MNRHTT=_"
Do
DoEvents
Loop Until IE.readyState = READYSTATE_COMPLETE
IE.document.getElementById("item-numbers").Value = "1195"
Set goBtn = IE.document.getElementById("bgs-submit")
goBtn.Click
Do
DoEvents
Loop Until IE.readyState = READYSTATE_COMPLETE
Dim sdd As String
sdd = IE.document.getElementById("availability-results").innerText
MsgBox sdd
End Sub
My problem is, that I only need the part "Item in in stock, more than 50 pcs. available" to be showed/ inserted in excel, but i don't manage to get it, as it has no separate ID.
<thead>
</thead><tbody>
</tbody>
Could anybody help me please?