ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

Vba±±¨îºô­¶

Vba±±¨îºô­¶

·Q¨Ï¥ÎVba±±¨îºô­¶¡A¬d¨ì¤@­Ó«öÁ䪺­ì©l½X¬°¤U¦C¡G
<button onclick="javascript:checkID();">½T»{</button>&nbsp;&nbsp;&nbsp;
³y¦¨µLªk¦Û°ÊÂI¿ï¡A½Ð°Ý¤j¤j¸Ó¦p¦ó³B²z¡H
§Ú¬O´µ¦h

¥»©«³Ì«á¥Ñ reangame ©ó 2017-6-17 00:08 ½s¿è
¥ÑcheckID³o­Ó¦WºÙ²q´ú¡A³o­Ó¥N½X¶È¶ÈÀË´ú¤F¿é¤JªºID¬O§_¥¿½T¡A²q´ú¼Ó¥D·Q­nªº®ÄªG¬O¦Û°Ê´£¥æªí³æ¡H¦pªG¬O¡A ...
Joforn µoªí©ó 2017-6-11 17:48


¨ä¹ê§Ú¥u¬O­n°µ¤@­Ó«Ü²³æªºµn¤J°Ê§@¦Ó¤w¡A¤§«e¨S°ÝÃD¡A¥i¬O³Ìªñ§ïª©«á´NµLªkµn¤J¤F¡A
µ{¦¡½X¼gªk¸ò¤U­±ªº¤@¼Ë¡G
  1.    1: Sub login()
  2.    2:     Dim loginID As String
  3.    3:     Dim loginPW As String
  4.    4:     loginID = "myid"
  5.    5:     loginPW = "mypw"
  6.    6:     
  7.    7:     Dim ie As InternetExplorer
  8.    8:     Dim doc As HTMLDocument
  9.    9:     Dim element As IHTMLElementCollection
  10.   10:     Set ie = CreateObject("InternetExplorer.Application")
  11.   11:     ie.navigate ("http://www.saveonbook.com/post/post.jsp?active=0")
  12.   12:     ie.Visible = True
  13.   13:     Do Until ie.readyState = READYSTATE_COMPLETE
  14.   14:         DoEvents
  15.   15:     Loop
  16.   16:     Set doc = ie.document
  17.   17:     Set element = doc.getElementsByName("LoginPA")
  18.   18:     element.Item(0).Value = loginID
  19.   19:     Set element = doc.getElementsByName("PasswordPA")
  20.   20:     element.Item(0).Value = loginPW
  21.   21:     Set element = doc.getElementsByName("img23")
  22. 22:     element.Item(0).Click
  23.   23: End Sub
½Æ»s¥N½X
¿ù»~ÂI´N¬O¦bµ{¦¡½XÂIÀ»µn¤Jªº¦a¤è²Ä22¦æ¡A¦]¬°§ä¤£¨ì«öÁäID¤F¡A¬d¬Ý«öÁäºô­¶­ì©l½X¤~µo²{Åܦ¨javascript checkID()
½Ð°Ý¦³¬Æ»ò¸Ñ¨M¤è¦¡¶Ü?
§Ú¬O´µ¦h

TOP

¦^´_ 3# VBALearner


    ¤£¦n·N«ä¡A¦]¬°¬O¤º³¡ºô¸ô¡AµLªk´£¨Ñºô§}¡A·PÁ±zªº¦^µª¡C
§Ú¬O´µ¦h

TOP

¥ÑcheckID³o­Ó¦WºÙ²q´ú¡A³o­Ó¥N½X¶È¶ÈÀË´ú¤F¿é¤JªºID¬O§_¥¿½T¡A²q´ú¼Ó¥D·Q­nªº®ÄªG¬O¦Û°Ê´£¥æªí³æ¡H¦pªG¬O¡A¨º»ò¤W­±ªº¥N½X¥i¯à¹F¤£¨ì­n¨D¡C
¥@¬É¨º»ò¤j¡A¥i§Ú·Q¥h­þ¡H

TOP

webbrowser1.Document.parentWindow.execScript "checkID();", "JavaScript"
¥@¬É¨º»ò¤j¡A¥i§Ú·Q¥h­þ¡H

TOP

¦^´_ 2# reangame

§Ú¤£¬O«Ü²M·¡VBA¥i¤£¥i¥H³B²z³o­Óª¬ªp...
¨Ì§Ú¼gª¦ÂΪº¸gÅç...¥i¯à.......¥ÎChromeªº¶}µo¤H­û¤u¨ã¥h¤F¸Ñ¤@¤Ujavascriptªº¨ç¼ÆcheckID()¬O¬Æ»ò¤º®e¡A³q±`·|¦³²Õ¦¨url¦r¦êªºµ{¦¡¡A«ö·Ó¨äµ{¦¡ÅÞ¿è¥ÎVBA´ê¥X°Ñ¼Æ¦A°ePOST
«Øijºô§}¶K¤W¨Ó¡A¦n¤è«K¤j®a¬ã¨s
¯u¤ß·PÁ¨C¤@¦ìÄ@·N¤À¨É©Ò¾Ç¡B«ü¾É·s¤âªº¤H!

TOP

½Ð°Ý¦³¤j¤j¯à°÷À°¦£¦^µª¤@¤U¶Ü¡H«ô°U«ô°U
§Ú¬O´µ¦h

TOP

        ÀR«ä¦Û¦b : ¸Ü¦h¤£¦p¸Ü¤Ö¡A¸Ü¤Ö¤£¦p¸Ü¦n¡C
ªð¦^¦Cªí ¤W¤@¥DÃD