µù¥U
µn¿ý
º¶
½×¾Âª©³W
¸T¤î¦Cªí
»¡©ú
¦a¹Ï
¼Æ¦ì®Ñ»
¨p¤H®ø®§ (0)
¤½¦@®ø®§ (0)
½×¾Â¥ô°È (0)
¨t²Î®ø®§ (0)
¦n¤Í®ø®§ (0)
©«¤l®ø®§ (0)
³Â»¶®a±Ú°Q½×ª©ª©
»
Excelµ{¦¡°Ï
» ºô¯¸³z¹LQueryTable¤U¸üªº¤é´Á°ÝÃD
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
µo©«
[µo°Ý]
ºô¯¸³z¹LQueryTable¤U¸üªº¤é´Á°ÝÃ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ªí©ó 2020-3-7 21:07
|
Åã¥Ü¥þ³¡©«¤l
[µo°Ý]
ºô¯¸³z¹LQueryTable¤U¸üªº¤é´Á°ÝÃD
¦U¦ì¤j¤j¦n,¤p§Ì·Q³z¹LVBA ªºQueryTable ¤U¸ü¹d¦ëºôªºªÑ²¼¸ê°T
ºô§}¦p¤U:
https://www.cnyes.com/twstock/ps_historyprice/2327.htm
¹J¨ìªº°ÝÃD¦p¤U:
µLªk¥Îµ{¦¡½X±±¨î°_©l¤é´Á.postText°e¥Xªº¸ê°T,µLªk¥¿½T¬d¸ß¨ì§Ú©Ò«ü©wªº¤é´Á
¦ýºô¯¸¹ê»Ú¤W¬O¥i¥H±±¨î°_©l¤é´Áªº
·Q½Ð°Ý¦U¦ì¤j¤jn¦p¦óקïµ{¦¡½X?
¤U¸ü¨ì(DL¤À¶)ªºµ{¦¡½X¦p¤U:
Sub test1()
Dim QT As QueryTable
Dim WebAddress As String
WebAddress = "http://www.cnyes.com/twstock/ps_historyprice/2327.htm"
With ThisWorkbook.Worksheets("DL")
.Cells.Clear
Set QT = .QueryTables.Add("URL;" & WebAddress, .Range("$A$1"))
End With
With QT
.PostText = "ctl00$ContentPlaceHolder1$startText=" & " 2019/01/01" & "&ctl00$ContentPlaceHolder1$endText=" & " 2020/03/06"
.WebTables = "1"
.Refresh False
.Delete
End With
End Sub
½Æ»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¤¤¨ú¤@"(¦ý¤£¯à«½Æ),©â
vba¥i§_¤£¥´¶}excelªí§Y¥iª¾¹Da1ªºÈ?
³Ì§Ö³tªº¤ñ¹ï¸ê®Æ¤è¦¡?
20Ó¬Û¦P¥\¯àComboBox¦p¦ó¥i¥H¬Ù¤u¼¶¼g?
¦¬ÂÃ
¤À¨É
PKKO
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
2
#
µoªí©ó 2020-3-8 14:13
|
Åã¥Ü¥þ³¡©«¤l
¦^´_
2#
Scott090
§¹¥þ¥i¥H!!!
·PÁ¤j¤j
§Ú³£§Ñ¤F¥i¥H±qºô§}ª½±µ¸Õ¸Õ¬Ý
«D±`·PÁÂ
¥u¬O«Ü©_©Ç,¤£ª¾¹D.postText ¿ù¦bþÃäµLªk¦¨¥\= =
¤£¹L¥i¥H¥Î´N«Ü´Î¤F,¦A¦¸¸U¤À·PÁ¤j¤j!!!
PKKO
TOP
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
3
#
µoªí©ó 2020-3-8 15:30
|
Åã¥Ü¥þ³¡©«¤l
¦^´_
4#
Scott090
ì¨Ó¦p¦¹
§Ú»{¬°¬Oºô§}°ÝÃD
¦]¬°§Ú¤§«e¦³§âªÅ®æ§R°£¹L
·PÁ¤j¤j
PKKO
TOP
ÀR«ä¦Û¦b :
¯¸¦b¥b¸ô¡A¤ñ¨«¨ì¥Ø¼Ð§ó¨¯W¡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¯»µ·