Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
form submit
hi,
i have some code that opens up a web page and fills in the user and password fields. then i have some code to submit the form. there is an OK and a CANCEL button in the internet ASP form. here is my code: .... With myDoc.getElementsByName("user")(0) ..Value = strUSERNAME End With myDoc.forms(0).submit i noticed that the web page is refreshed and almost looks like it is going to go to another page, but in the end it is just refresh, with the username and password cleared out. what am i doing wrong? i simply need to simulate clicking the OK button. thanks in advance, geebee |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
form submit
And the link with Excel is...?
-- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "geebee" wrote: hi, i have some code that opens up a web page and fills in the user and password fields. then i have some code to submit the form. there is an OK and a CANCEL button in the internet ASP form. here is my code: ... With myDoc.getElementsByName("user")(0) .Value = strUSERNAME End With myDoc.forms(0).submit i noticed that the web page is refreshed and almost looks like it is going to go to another page, but in the end it is just refresh, with the username and password cleared out. what am i doing wrong? i simply need to simulate clicking the OK button. thanks in advance, geebee |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
form submit
hi,
here is some more code: Dim myIE As New InternetExplorer 'New ' Dim myURL As String Dim myDoc As HTMLDocument Dim strSearch As String 'Set starting URL and search string myURL = "https://securesitenotprovided...asp" 'Make IE navigate to the URL and make browser visible myIE.navigate myURL myIE.Visible = True 'Wait for the page to load Do While myIE.Busy Or myIE.readyState < READYSTATE_COMPLETE DoEvents Loop 'Set IE document into object Set myDoc = myIE.document hopefully this will allow you to help me out... thanks in advance, geebee "Wigi" wrote: And the link with Excel is...? -- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "geebee" wrote: hi, i have some code that opens up a web page and fills in the user and password fields. then i have some code to submit the form. there is an OK and a CANCEL button in the internet ASP form. here is my code: ... With myDoc.getElementsByName("user")(0) .Value = strUSERNAME End With myDoc.forms(0).submit i noticed that the web page is refreshed and almost looks like it is going to go to another page, but in the end it is just refresh, with the username and password cleared out. what am i doing wrong? i simply need to simulate clicking the OK button. thanks in advance, geebee |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
JSP's form-submit & Excel's Web Query.... | Excel Programming | |||
Excel VBA to click 'submit' on form | Excel Programming | |||
Form Input--Submit | Excel Programming | |||
Form with submit button | Excel Worksheet Functions | |||
Submit User Form Contents to next available row | Excel Programming |