- ©«¤l
- 5923
- ¥DÃD
- 13
- ºëµØ
- 1
- ¿n¤À
- 5986
- ÂI¦W
- 0
- §@·~¨t²Î
- win10
- ³nÅ骩¥»
- Office 2010
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW°ò¶©
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2022-1-23
|
¦^´_ 1# PKKO - Option Explicit
- Sub Ex()
- Dim hq As Variant, i As Integer, ii As Integer
- Set hq = CreateObject("MSXML2.XMLHTTP.3.0")
- hq.Open "get", "http://rate.bot.com.tw/xrt/flcsv/0/day", False
- hq.send
- '**Split ¨ç¼Æ ¶Ç¦^¤@Ó³¯¦C¯Á¤Þ±q¹s¶}©lªº¤@ºû°}¦C¡A¥¦¥]§t«ü©w¼Æ¥Øªº¤l¦r¦ê¡C
- '**»yªk Split(expression[, delimiter[, limit[, compare]]])
- hq = Split(hq.responsetext, vbCrLf)
- '**vbCrLf -> Chr(13) + Chr(10) = µ²¦X´«¦æ¦r¤¸»P´_¦ì¦r¤¸¡C
- ActiveSheet.Cells.Clear '**§@¥Î¤¤¤u§@¶ªº©Ò¦³Àx¦s®æ,²M°£¤å¦r¤Î¨ä®æ¦¡
- '***Ū¨ú¸ê®Æ
- For i = 0 To UBound(hq)
- For ii = 0 To UBound(Split(hq(i), ","))
- ActiveSheet.Range("a1").Offset(i, ii) = Split(hq(i), ",")(ii)
- Next
- Next
- '**Ū¨ú¸ê®Æ§¹²¦
- MsgBox Join(hq, vbCrLf)
- End Sub
½Æ»s¥N½X |
|