ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   press button "entra" in web page (https://www.excelbanter.com/excel-programming/332926-press-button-entra-web-page.html)

sal21[_56_]

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


liquidhot[_3_]

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


sal21[_57_]

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


liquidhot[_2_]

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


sal21[_58_]

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


liquidhot[_5_]

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


sal21[_59_]

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


liquidhot[_7_]

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



All times are GMT +1. The time now is 09:38 AM.

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