- ©«¤l
- 2035
- ¥DÃD
- 24
- ºëµØ
- 0
- ¿n¤À
- 2031
- ÂI¦W
- 0
- §@·~¨t²Î
- Win7
- ³nÅ骩¥»
- Office2010
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-3-22
- ³Ì«áµn¿ý
- 2024-2-1
|
¦^´_ 4# white5168
¦^´_ 2# vesperlee
½Ð¸Õ¸Õ¬Ý¡I- Private Sub CommandButton1_Click()
- ' Const url As String = "http://jsjustweb.jihsun.com.tw/z/zc/zck/zck_6257.asp.htm"
- Const url As String = "http://jsjustweb.jihsun.com.tw/z/zc/zcx/zcx_6257.asp.htm" ' ¥¿½Tªº
- Cells.Clear
- Set ie = CreateObject("internetexplorer.application") '¨Ï¥Î¦¹¤è¦¡¥i¥H§K°£ "³]©w¤Þ¥Î¶µ¥Ø"
- With ie
- .Visible = False 'True¬°¶}±Òie, False¬°¤£¶}±Òie
- .Navigate url
- Do While .ReadyState <> 4 'µ¥«Ýºô¶¶}±Ò
- DoEvents
- Loop
- .ExecWB 17, 2 'Select All
- .ExecWB 12, 2 'Copy selection
- Range("A1").Activate
- ActiveSheet.PasteSpecial Format:="HTML", Link:=False, DisplayAsIcon:= _
- False, NoHTMLFormatting:=True
- End With
- Columns("A:B").Delete ' ±N¶×¤J®É A¡BB ¨âÄæ²¾°£¡A 쥻 C:I ªºÄæ¦ì¥þ³¡¥ª¾a¡A ¦¨¬° A:I
- ie.Quit
- MsgBox "¸ê®Æ½Æ»sµ²§ô" ' Â÷¶}«eÅã¥Ü¤@¤pµøµ¡´£¿ô¡A«ö¥¦«á§Yµ²§ô¡C
- End Sub
½Æ»s¥N½X
|
|