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

[µo°Ý] ¥i§_¥Î°j°é©ÎÅܼƶפJ¤j¶q¸ê®Æ¡H

[µo°Ý] ¥i§_¥Î°j°é©ÎÅܼƶפJ¤j¶q¸ê®Æ¡H

½Ð°Ý¤@¤U¦U¦ì¥ý¶i¡A³o¬O§Ú±q¬Yºô¯¸¶×¤JEXCELªºµ{¦¡½X¡A¤£ª¾¹D¯à¤£¯à¨Ï¥Î°j°é©ÎÅܼƪº¤è¦¡¨ú¨ä¥L­ÓªÑ¬Û¦Pªº°]³ø¡H
¤]´N¬Oµ{¦¡½X¤¤ªº2330¥i¥H¥Î°j°é©ÎÅܼƨÓÅܧó¶Ü¡HÀµ½Ð¦U¦ìVBA°ª¤â«üÂI¡AÁÂÁ¡I
https://www.cathayholdings.com/securities/exclude_AL/market.aspx?btn=1-00-00&st=2330
  1. Sub §ì©u·l¯qªí¸ê®Æ()
  2.     With ActiveSheet.QueryTables.Add(Connection:= _
  3.         "URL;https://djinfo.cathaysec.com.tw/Z/ZC/ZCQ/ZCQ.DJHTM?A=2330", Destination _
  4.         :=Range("$A$1"))
  5.         .Name = "ZCQ.DJHTM?A=2330"
  6.         .FieldNames = True
  7.         .RowNumbers = False
  8.         .FillAdjacentFormulas = False
  9.         .PreserveFormatting = True
  10.         .RefreshOnFileOpen = False
  11.         .BackgroundQuery = True
  12.         .RefreshStyle = xlInsertDeleteCells
  13.         .SavePassword = False
  14.         .SaveData = True
  15.         .AdjustColumnWidth = True
  16.         .RefreshPeriod = 0
  17.         .WebSelectionType = xlSpecifiedTables
  18.         .WebFormatting = xlWebFormattingNone
  19.         .WebTables = "3"
  20.         .WebPreFormattedTextToColumns = True
  21.         .WebConsecutiveDelimitersAsOne = True
  22.         .WebSingleBlockTextImport = False
  23.         .WebDisableDateRecognition = False
  24.         .WebDisableRedirections = False
  25.         .Refresh BackgroundQuery:=False
  26.     End With
  27. Sub End
½Æ»s¥N½X

¦^´_ 94# smart3135

¤£¬O¤£¦æ¦Ó¬O§A¨S¦³»{¯u·Q

³o¬O¥u¨ä¤¤¤@ºØµ¥«Ýªº¤èªk

for i=XXX to XXX
Application.Wait Now + TimeValue("00:00:03")

next

TOP

¦^´_ 93# smart3135
´ú¸Õ¤F¤@¤U¡A¥Î·sºô­¶¥h§ì¸ê®ÆÁÙ¬O¦³¬y¶q­­¨î¡A¤@¼Ë¨ì¬ù25ÀÉ´N§ì¤£¤F¤F
»yªk¤¤¤]¥¼¥[¤JIE.Application¡A¨S¿ìªk°µ IE.Quit¡A©Ò¥H¬Ý¨Ó³o­ÓVBAÁÙ¬O¨S¿ìªk¯}¸Ñ¬y¶q­­¨î

TOP

¦^´_ 87# GBKEE
ª©¥D¡A¦A½Ð±Ð¤@¤U¡A§Ú¦³­«·s¼g¤F¤@­ÓVBA¡A©M­ì¨Ó§ìªº¤è¦¡¤£¤@¼Ë¡A¬O¥ÎHTMLºô§}¤U¥h§ì
¥i¥Hª½±µ±a¤JÅܼƪѲ¼¸¹½Xª½±µ§ì¡A°ÝÃD¬O§ì¤U¨Óªº¤é´Á®æ¦¡¦b¼g¤J¤å¦rÀɮɡA´N·|¦Û¤vÂà´«¦¨2018/X/X
¦³§Ú¸ÕµÛ¦b¼g¶i¤å¦rÀÉ«e±NÀx¦s®æ®æ¦¡Åܧ󦨤å¦r¡A¦ý«o·|Åã¥Ü¦¨¥t¤@­Ó¼Æ¦r(¹Ï¤ùºñ®Ø³B)
¤£ª¾¹D¸Ó«ç»ò¼g¤~¯àÅý¤é´ÁÅã¥Ü¦bexcelªºµ²ªG©Mºô­¶¤@¼Ë¡A¨Ã¥B³]©w¦¨¤å¦r®æ¦¡¡A¼g¶i¤å¦rÀɮɤ~¤£·|¤SÂà´«¦¨¤é´Á®æ¦¡
¦A½Ð±z«ü¾É¤@¤U¡AÁÂÁ¡C

¤W¥«¦~¦¨¥æ¸ê°T-·sºô­¶.zip (31.88 KB)

TOP

¥»©«³Ì«á¥Ñ smart3135 ©ó 2018-2-12 22:57 ½s¿è

¦^´_ 91# joey0415
¤£¦n·N«ä ½Ð°Ý­n«ç»ò³]©w¤T¬í§ì¤@¦¸ ¤£¬O«ÜÀ´³o­Ó»yªk
§Ú¥Ø«e¬O¼È®É§âIE.Applictation©ñ¦b°j°é¤¤¡Aµ¥§ì§¹¤@ÀÉ«á¦A¸õ¤U¤@ÀÉ«e¦A±NIE.Quit
ÂêIPªº±¡§Î¦³¤j´T§ïµ½¡A°¸¦³µo¥Í¡A¦ý¤´¤ñ­ì¨Ó³Ì¦h¥u§ì25Àɦn«Ü¦h¤F
¤W¥«¦~¦¨¥æ¸ê°T-¯}¸Ñ¬y¶q­­¨îª©¥».zip (26.55 KB)

TOP

¦^´_ 90# smart3135

³t«×¥u¯à¨C¤T¬í§ì¤@¦¸´N¤£·|Âêip

ºC¤@ÂI·íµM§ó¦n

¥Ø«e§Ú¤]¬O³o¼Ë¸Õ¥X¨Óªº

TOP

¦^´_ 89# smart3135
·PÁª©¥D¦^ÂСA§ä¤F¤@¤U¡A§ä¤£¨ì¬ÛÃöªººô­¶¡A¥Ø«e¥i¥H¨Ï¥Îªº¤è¦¡´N¬O¥Î¤@¼Ëªºµ{¦¡¨C¦¸¸ê®Æ¥u¯à§ì25µ§¥ª¥k
·íµLªk§ìªº®É­Ô´N±N¼Æ¾Ú¾÷Ãö±¼­«¶}¡Aµ¥ºô¸ô³s½u´N¥i¥H¦A§ì25µ§¡A900¦hµ§¸ê®Æ­nºCºC§ì¡A«¢

TOP

[ª©¥DºÞ²z¯d¨¥]
  • GBKEE(2018/2/12 17:12): ÃÒ¥æ©Ò§ïª©«á,¥Îµ{¦¡¤j¶q¤U¸ü¸ê®Æ¦³ IP ªººÞ¨î, ½Ð¥t§ä¬Û¦P©Ê½èºô­¶¬Ý¬Ý

¦^´_ 87# GBKEE
ª©¥D±z¦n¡A¤S¨Ó½Ð±Ð±z¤F¡A¥b¦~«eÃÒ¥æ©Ò§ïª©«á¦³½Ð±zÀ°¦£¡A«á¨Ó½T¹ê¥i¥H§ì¸ê®Æ¤F
¦ý¤µ¦~´ú¸Õ¡A¤U¸ü¨S´X­Ó´N·|¥d¦í¡A§Ú¦A¥h¶}ÃÒ¥æ©Òºô­¶´N·|¶}¤£°_¨Ó
¦³½ÐªB¤ÍÀ°¦£´ú¸Õ¡A¥L­Ìªº¹q¸£¬O¥i¥H¶}ªº¡A³o¬O¤£¬Oªí¥Ü¦]¬°§Ú¦b§ì¤j¶q¸ê®Æ
©Ò¥H·|¦³¬y¶q©ÎÀW¼eªº­­¨î¡H³sµ²¤¤ªº¤å³¹¦ü¥G¤]¬O»¡©ú¦p¦¹
¤£ª¾¹Dµ{¦¡½XÁÙ¦³¨S¦³¯à­×¥¿ªº¦a¤èÅý¥¦¥i¥H¥¿±`§ì¸ê®Æ¡AÁÂÁÂ
https://www.wearn.com/bbs/t911387.html
¤W¥«¦~¦¨¥æ¸ê°T.zip (26.12 KB)
¤W¥«¤ë¦¨¥æ¸ê°T.zip (40.75 KB)

TOP

¦^´_ 87# GBKEE
·PÁª©¥Dªü¡A¯uªº¤Ó¹ê¥Î¤F¡A§ÚÁÙ¦³¦Û¤v­×§ï¤@¨Ç¤º®e²Å¦X§Ú·Q­nªº®æ¦¡
¥t¥~¤W¥«¦~¦¨¥æ¸ê°T¬O¨Ì±z«e¤@½g¦^ÂЪº¤º®e§Ú¤]µy§@­×§ï¡A¤@¼Ë¥i¥H¥¿±`§ì¸ê®Æ¤F
¯u¬O¨ü±Ð¤F:handshake

TOP

¦^´_ 86# smart3135

ÃÒ¥æ©Òºô­¶¦³¬y¶qºÞ¨î.ªþÀɦ³­«·s­×§ï¤@¨Ç¦a¤è.

¤W¥«¤ë¦¨¥æ¸ê°T.rar (52.87 KB)
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

        ÀR«ä¦Û¦b : ¤H¥Í³Ì¤jªº¦¨´N¬O±q¥¢±Ñ¤¤¯¸°_¨Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD