| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
press button "entra" in web page
... I have this macro but i dont know the command to press the butto "entra" after i have inserted the personl detail.... Tks all... Sub PROVA() ' Prepare to open the web page Set ie = CreateObject("InternetExplorer.Application") With ie .Visible = True .Navigate "http://liberomail.libero.it/" ' Loop until the page is fully loaded Do Until Not .Busy DoEvents Loop ' Make the desired selections on the web page and click the submi Button ' IE ie.document.all.Item LEGGE NELLA PAGINA html il tag d riferimento Set ipf = ie.document.all.Item("LOGIN") ipf.Value = "123456" Set ipf = ie.document.all.Item("PASSWD") ipf.Value = "abcd" Set ipf = ie.document.all.Item("CHOICE") ipf.Value = "iol" '??????????????????????? here the command to press the button "entra" '??????????????????????? ' Loop until the page is fully loaded Do Until Not .Busy DoEvents Loop End With ' Close the internet explorer application ie.Quit End Su -- sal2 ----------------------------------------------------------------------- sal21's Profile: http://www.excelforum.com/member.php...nfo&userid=204 View this thread: http://www.excelforum.com/showthread.php?threadid=38247 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
press button "entra" in web page
Try this: ie.Document.Forms(0).submit() The number 0 is the first form on the page if there are multiple form you may need to adjust as needed -- liquidho ----------------------------------------------------------------------- liquidhot's Profile: http://www.excelforum.com/member.php...fo&userid=2467 View this thread: http://www.excelforum.com/showthread.php?threadid=38247 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
press button "entra" in web page
liquidhot Wrote: Try this: ie.Document.Forms(0).submit() The number 0 is the first form on the page if there are multiple form you may need to adjust as needed. Tks for fast reply but i have problem to integrate your command line See the attached web page... Tks +------------------------------------------------------------------- |Filename: submit.txt |Download: http://www.excelforum.com/attachment.php?postid=3541 +------------------------------------------------------------------- -- sal2 ----------------------------------------------------------------------- sal21's Profile: http://www.excelforum.com/member.php...nfo&userid=204 View this thread: http://www.excelforum.com/showthread.php?threadid=38247 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
press button "entra" in web page
What's the problem? Does the line not work -- liquidho ----------------------------------------------------------------------- liquidhot's Profile: http://www.excelforum.com/member.php...fo&userid=2467 View this thread: http://www.excelforum.com/showthread.php?threadid=38247 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
press button "entra" in web page
liquidhot Wrote: What's the problem? Does the line not work? Sintiax error if i insert your line he ' Make the desired selections on the web page and click the submit Button ' IE ie.document.all.Item LEGGE NELLA PAGINA html il tag di riferimento Set ipf = ie.Document.all.Item("LOGIN") ipf.Value = "123456" Set ipf = ie.Document.all.Item("PASSWD") ipf.Value = "abcd" Set ipf = ie.Document.all.Item("CHOICE") ipf.Value = "iol" '??????????????????????? ie.Document.Forms(0).submit() '??????????????????????? ' Loop until the page is fully loaded Do Until Not .Busy DoEvents Loop -- sal21 ------------------------------------------------------------------------ sal21's Profile: http://www.excelforum.com/member.php...fo&userid=2040 View this thread: http://www.excelforum.com/showthread...hreadid=382477 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
press button "entra" in web page
Can you give me the syntax error? (I'm not an expert by any means, bu I'm good at troubleshooting! :) -- liquidho ----------------------------------------------------------------------- liquidhot's Profile: http://www.excelforum.com/member.php...fo&userid=2467 View this thread: http://www.excelforum.com/showthread.php?threadid=38247 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
press button "entra" in web page
liquidhot Wrote: Can you give me the syntax error? (I'm not an expert by any means, but I'm good at troubleshooting! :) ) ... i have the sintiax error on your line but vba not tell me other;-( The line is in red when i insert: ie.Document.Forms(0).submit() into the code. -- sal21 ------------------------------------------------------------------------ sal21's Profile: http://www.excelforum.com/member.php...fo&userid=2040 View this thread: http://www.excelforum.com/showthread...hreadid=382477 |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
press button "entra" in web page
try Set ipf = ie.Document.Forms(0).submit() I don't know if that will work or not -- liquidho ----------------------------------------------------------------------- liquidhot's Profile: http://www.excelforum.com/member.php...fo&userid=2467 View this thread: http://www.excelforum.com/showthread.php?threadid=38247 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I press "enter" but it doesn't move to next row down. | Excel Discussion (Misc queries) | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| When i press "ENTER", it move rightward, (i want it to go down!) | Excel Discussion (Misc queries) | |||
| HELP! Clicking "$" button changes format to ";;" not what it shoul | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
![sal21[_56_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
