- ©«¤l
- 361
- ¥DÃD
- 57
- ºëµØ
- 0
- ¿n¤À
- 426
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- 2003,2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-13
- ³Ì«áµn¿ý
- 2022-12-8
|
¦^´_ 18# wufonna
¨ä¹ê´N¬O¿ý»s¦n«á¡A§â¬Y¦æµù¸Ñ«á¡A¦A°õ¦æ¡A¦pªG¥i¥H´Nªí¥Ü¸Ó¦æ¤£»Ý¦æ¡A¦]¬°¿ý»sªº³q±`·|¦³«Ü¦h¤£nªº¥N½X
¿ý¤[¤F´Nª¾¹D¡K
³Ì«á¥[¤W.delete
ªí¥Ü¨ú®ø³s½u- Sub ¥¨¶°1()
- With ActiveSheet.QueryTables.Add(Connection:= _
- "URL;https://djinfo.cathaysec.com.tw/Z/ZC/ZCX/ZCXNEWCATHAYSEC.DJHTM?A=2882", _
- Destination:=Range("$A$1"))
- .WebFormatting = xlWebFormattingNone
- .WebTables = "2,3"
- .Refresh BackgroundQuery:=False
- .Delete
- End With
- End Sub
½Æ»s¥N½X |
|