µù¥U
µn¿ý
º¶
½×¾Âª©³W
¸T¤î¦Cªí
»¡©ú
¦a¹Ï
¼Æ¦ì®Ñ»
¨p¤H®ø®§ (0)
¤½¦@®ø®§ (0)
½×¾Â¥ô°È (0)
¨t²Î®ø®§ (0)
¦n¤Í®ø®§ (0)
©«¤l®ø®§ (0)
³Â»¶®a±Ú°Q½×ª©ª©
»
Excelµ{¦¡°Ï
» ºô¯¸µLdocument¥i§ì¨ú°ÝÃD
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
µo©«
ºô¯¸µLdocument¥i§ì¨ú°ÝÃD
PKKO
µoµu®ø®§
¥[¬°¦n¤Í
PKKO
(PKKO)
·í«eÂ÷½u
UID
14751
©«¤l
549
¥DÃD
152
ºëµØ
0
¿n¤À
691
ª÷¿ú
691
ÂI¦W
0
§@·~¨t²Î
WIN7
³nÅ骩¥»
OFFICE 2010
¾\ŪÅv
50
©Ê§O
¨k
¦b½u®É¶¡
506 ¤p®É
µù¥U®É¶¡
2013-8-10
³Ì«áµn¿ý
2022-9-7
¡@¼ÊºÙ:
PKKO
°ª¤¤¥Í
©«¤l
549
¥DÃD
152
ºëµØ
0
¿n¤À
691
ÂI¦W
0
§@·~¨t²Î
WIN7
³nÅ骩¥»
OFFICE 2010
¾\ŪÅv
50
©Ê§O
¨k
µù¥U®É¶¡
2013-8-10
³Ì«áµn¿ý
2022-9-7
1
#
¸õÂà¨ì
»
˧Ǭݩ«
¥´¦L
¦rÅé¤j¤p:
t
T
µoªí©ó 2019-9-24 14:03
|
¥u¬Ý¸Ó§@ªÌ
ºô¯¸µLdocument¥i§ì¨ú°ÝÃD
https://bet.hkjc.com/football/index.aspx?lang=ch
¹³³oºØaspxªººô¯¸
¦pªGª½±µ¿é¤J¤¸¯À
¬O¥i¥H±±¨î
¦ý¨S¦³name ¨S¦³ id ªº¤¸¯À
¤SµLªk¶]for each e in ie.document
¸Ó¦p¦ó«ü©w¤¸¯À°õ¦æclick°Ê§@
©Î¬O¦p¦ó§ì¨úTABLE¸ê®Æ©O?
Set ie = CreateObject("InternetExplorer.Application")
ie.Visible = True
ie.Navigate "https://bet.hkjc.com/football/results/results.aspx?lang=CH"
Application.Wait (Now + TimeValue("00:00:08"))
ie.document.getElementById("secMenuFB").Click
½Æ»s¥N½X
¼Ó¥D¼ö©«
¦p¦ó¥Îvbaª¾¹D§@¥ÎÀx¦s®æ&Äæ&¦Cªº¦ì¸m
ExcelÀɮצ³¿ìªk¨¾¤î§O¤H½Æ»s±NÀÉ®×±a¨«¶Ü?
Userform³Ì¤j¤Æ(¥B¤º®e¤ñ¨Ò¦Û°Ê©ñ¤j?)
¦p¦ó²¾°£°}¦C¤º«½Æªº³¡¤À(STRING)
¦³¤Hª¾¹D¥ß¬W¸I¸Ó«ç¼Ëpºâ¶Ü?(±Æ¦C²Õ¦X°ÝÃD
§A¶}±ÒÀɮ׮ɷ|°Ý§A¬O§_n§ó·s¶Ü?¤À¨É¨ú®ø³s
¦p¦ó³z¹LVBAÀH¾÷"¸U¤¤¨ú¤@"(¦ý¤£¯à«½Æ),©â
³Ì§Ö³tªº¤ñ¹ï¸ê®Æ¤è¦¡?
vba¥i§_¤£¥´¶}excelªí§Y¥iª¾¹Da1ªºÈ?
20Ó¬Û¦P¥\¯àComboBox¦p¦ó¥i¥H¬Ù¤u¼¶¼g?
¦¬ÂÃ
¤À¨É
PKKO
ÀR«ä¦Û¦b :
¤â¤ß¦V¤U¬O§U¤H¡A¤â¤ß¦V¤W¬O¨D¤H¡F§U¤H§Ö¼Ö¡A¨D¤HµhW¡C
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
EXCEL±MÄÝ°Q½×°Ï
Excel£¸¯ë°Ï
Excelµ{¦¡°Ï
¶i¶¥À³¥Î±M°Ï
OFFICE ¨t¦C
Word
PowerPoint
Access
Office¤£¤À°Ï
µ{¦¡»y¨¥
VB »P VB.Net
C »P C#
Java »P J#
µ{¦¡³]p¤£¤À°Ï
¸ê®Æ®w
ORACLE
My SQL
MS SQL
ºô¶³]p
ASP »P ASP.NET
PHP
PHP+MySQL ¤Jªù¹ê§@
JavaScript
FLASH / ActionScript
HTM/ HTML/ CSS
ºô¶³]p¤£¤À°Ï
¹q¸£»P§@·~¨t²Î
¹q¸£¦UºØµwÅé°Q½×
¤@¯ë¹q¸£³nÅé°Q½×
½×¾Â¨Æ°È
ºÞ²z¤½§i
§ë¶D¤Ï¬M
·s¤â´ú¸Õ
·R ¡E ¥Í¬¡
¤½¯q§G§iÄæ
¥Í¬¡»P·P°Ê
[¦¬Âæ¹¥DÃD]
[Ãöª`¦¹¥DÃDªº·s¦^´_]
[³q¹L QQ¡BMSN ¤À¨Éµ¹ªB¤Í]
¥Ó½Ð¤Í±¡Ãì±µ
Facebook¯»µ·