Calling Javascript Function From Access VBA
in access vba I'm able to retrieve an href tag from a website, however I found out that the href value triggers a javascript function rather than a link. The javascript function di
Solution 1:
Solved it, I used IE.Document.parentWindow.excScript(b.href,"Javacript") to call the javascript function while set its IE.Document to my current one.
'b.Click
Call HTML.parentWindow.execScript(b.href, "Javascript")
Do: Loop While ie.Busy Or ie.ReadyState <> 4
Set blist = HTML.getElementsByTagName("td")
For Each c In blist
address = c.innerText
If InStr(address, "Email: ") Then
Debug.Print address
End If
Next c
Set HTML = Nothing
Exit Function
Post a Comment for "Calling Javascript Function From Access VBA"