- ©«¤l
- 41
- ¥DÃD
- 8
- ºëµØ
- 0
- ¿n¤À
- 64
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- OFFICE2010
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2015-3-11
- ³Ì«áµn¿ý
- 2020-10-7
|
§Ú¥Î¤F§Aªºcode, ¥u¬O´«¦¨¥É¤sÃÒ¨éºô§}
µ²ªGÁÙ¬O¨S¤ÏÀ³¡C
Y§Úªº¹q¸£¤£¯àrun¡A¤]³\¬OÀô¹Ò°ÝÃD¡C¥u¬O§Ú·d¤£À´¡A¦P¼Ëªºcode , §Ú¥h¦n´XÓ¤Hªº¹q¸£¸Õ¹L¡AÁÙ¬O³£¤£¦æ¡C
Sub ¥¨¶°1()
Cells.Clear
sname = 1101
Set myQT = ActiveSheet.QueryTables.Add(Connection:="URL;http://sjmain.esunsec.com.tw/z/zc/zcc/zcc_" & sname & ".djhtm", Destination:=Range("$A$1"))
With myQT
.WebFormatting = xlWebFormattingNone
.Refresh BackgroundQuery:=False
.Delete
End With
Set myQT = Nothing
End Sub |
|