ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How can I call a JavaScript Function from Excel VBA (https://www.excelbanter.com/excel-programming/359035-how-can-i-call-javascript-function-excel-vba.html)

[email protected]

How can I call a JavaScript Function from Excel VBA
 
I am Trying to Automate the opening and copying of a information from a
website into Excel. In order to do that I first need to login... I
was able in the past to just use something like:

Set ie = CreateObject("InternetExplorer.Application")
With ie

..Visible = True

' Go to login page
..Navigate "http://www.PageIamTryingToLogon.com/"

' Loop until the page is fully loaded
Do Until .ReadyState = 4
DoEvents
Loop

' Make the desired selections on the web page and click the submit
Button

Set ipf = ie.Document.all.Item("userid")
ipf.Value = "FirstName.LastName"

Set ipf = ie.Document.all.Item("passwd")
ipf.Value = "MyPassword"

Set ipf = ie.Document.all.Item("logon")
ipf.Click

The "ipf.Click" no longer works... after they changed the website...
Now the login section code looks like that:
"...
<td valign="middle" style="HEIGHT: 23px" align="left"<input
onkeypress="return(sendLoginCheck(false));"
onblur="setLoginFlag(false);" onfocus="setLoginFlag(true);"
type="password" maxLength="30" size="20" name="passwd"</td


<td vAlign="baseline" align="right" colSpan="2"<span
style="CURSOR:hand; cursor: pointer"
onkeypress="sendLoginCheck(false);return(false);"
onclick="sendLogin(this);return(false);"<img src="/Login.gif"
border=0</span
</td

...."

I would like to find a way to submit the "sendLoginCheck" in IE from
within Excel..
Any help is welcome!!!



All times are GMT +1. The time now is 12:20 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com