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

[µo°Ý] ºô­¶ÂI¿ï«ü©wÄæ¦ì

[µo°Ý] ºô­¶ÂI¿ï«ü©wÄæ¦ì

¥»©«³Ì«á¥Ñ gn699990 ©ó 2014-1-12 11:25 ½s¿è

¦U¦ì°ª¤â
½Ð°Ý¤@¤U
¤p§Ì¦³¦b¨Ï¥ÎVBA¦Û°Ê§ìºô­¶¸ê®Æ

¦ý¥Ø«e¹J¨ì¤@­Ó°ÝÃD
¦p¦ó¼¶¼gVBA
¶}±Ò¦¹ºô­¶«á
http://www.gretai.org.tw/ch/stock/statistics/monthly/st42.php
¥i¥HÅý·Æ¹«ÂI¿ï¹Ï¤W¤§°é¿ïÄæ¦ì

¿é¤J¥N½X«á
¨Ã¦Û°Ê«ö¤UENTER¶s
¸Õ¦n¤[³£§Ë¤£¥X¨Ó

¥H«e³oºô­¶¬O¦³"¬d¸ß"¶s
¦ý¬O²{¦b§â¸Ó¶s²¾°£¤F
¥Ø«eµ{¦¡¥i¥H§â¥N¸¹¿é¤J¨ì¸ÓÄæ¦ì
«o¤£ª¾¦p¦ó¦b¿é¤J«á        ¦Û°Ê«ö¤UENTER
³Â·Ð°ª¤â¸Ñ´b¤@¤U

¦^´_ 1# gn699990

¥»°Q½×°Ï·j´M //www.gretai.org.tw/ch/stock/statistics/monthly/st42.php
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

¦^´_ 2# GBKEE
·PÁÂG¤j¦^¤å
±z¬O«ü³o½g¶Ühttp://forum.twbts.com/thread-11046-1-1.html
¦ý§Ú¨Ã«D­n¥ÎIQYªº¤è¦¡°µ¶×¤J

¦Ó¬O­n¨Ï¥ÎVBA¥h±±¨îºô­¶«ü¥O
¦b¸ÓÄæ¦ì¿é¤J¥N¸¹«á   «ö¤UENTERÁä

¥Ø«e­Ó¤H¥\¤O¥u¦³¿ìªkÅýVBA¦b¸ÓÄæ¦ì¿é¤J¥N¸¹        ¦ýENTER·d¤£¥X¨Ó

TOP

§Ú³B²zªº¤è¦¡¤ñ¸û¹³³o½g
http://forum.twbts.com/viewthread.php?tid=5956



¥u¬O¥Ø«eºô­¶§â"¬d¸ß"Á䮳±¼
§ï¦¨»Ý­n"ÂI¿ï"«á   «ö¤UENTER
¬õ¦r³¡¤À³o¨BÆJ          ¥Ø«eµLªk§JªA

TOP

¦^´_ 4# gn699990
§Q¥Îformªºsubmit´£¥æ
  1. Sub Test()
  2.   Dim oIE As Object, oNode As Object
  3.   
  4.   Set oIE = CreateObject("InternetExplorer.Application")
  5.   With oIE
  6.     .Visible = True
  7.     .navigate "http://www.gretai.org.tw/ch/stock/statistics/monthly/st42.php"
  8.     Do While .Busy Or .ReadyState <> 4: DoEvents: Loop
  9.     Set oNode = .document.getelementbyid("input_stock_code")
  10.     oNode.Value = 1256
  11.     oNode.ParentNode.submit
  12.     Do While .Busy Or .ReadyState <> 4: DoEvents: Loop
  13.    
  14.     Stop
  15.    
  16.     .Quit
  17.   End With
  18. End Sub
½Æ»s¥N½X

TOP

¦^´_ 5# stillfish00


·PÁÂS¤j
Á`ºâ·d©w
§xÂZ¤F¦n¤[
¹ê¦b¤Ó¦hÁ¤F

TOP

¥»©«³Ì«á¥Ñ smart3135 ©ó 2014-4-22 10:37 ½s¿è

¦^´_ 5# stillfish00
S¤j¡A§Ú·Ó±zªºµ{¦¡½X°õ¦æ¡Aµ²ªG¬O±N1256ªº¦~¦¨¥æ¸ê°T¥HIE¶}±Ò¡A¥i¥Hª½±µ¬Ý¨ì1256ªº¦~¦¨¥æ¸ê°T¡A¦ý¤£ª¾¹D¦³¨S¦³¤èªk¯àª½±µ±N¦~¦¨¥æ¸ê°Tªº¤º®eª½±µ¶×¤J¨ì¤u§@ªí¤¤©O¡H¬O­n¥HVBAªº¤è¦¡¨Ó¶×¤J¡A¦Ó¤£¬OIQY¡A¥t¥~¤£ª¾¹D¤ë¦¨¥æ¸ê°T¦³¨S¦³¿ìªk¨Ì¼Ëµe¸¬Äª¡AÀµ½Ð«üÂI¡I

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡¦¨´N¤@¤Á¡j®É¶¡¥i¥H³y´N¤H®æ¡A¥i¥H¦¨´N¨Æ·~¡A¤]¥i¥HÀx¿n¥\¼w¡C
ªð¦^¦Cªí ¤W¤@¥DÃD