EXCELºô¶¬d¸ß¦p¦óÁ׶}¤£¦s¦bºô¶
- ©«¤l
- 29
- ¥DÃD
- 15
- ºëµØ
- 0
- ¿n¤À
- 50
- ÂI¦W
- 0
- §@·~¨t²Î
- WINDOW XP
- ³nÅ骩¥»
- 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- TAIPEI
- µù¥U®É¶¡
- 2010-5-4
- ³Ì«áµn¿ý
- 2021-11-24
|
EXCELºô¶¬d¸ß¦p¦óÁ׶}¤£¦s¦bºô¶
TEST´î¸ê¬d¸ß.rar (9.56 KB)
¤p§Ì¨C¤é¥ÎEXCELºô¶¬d¸ß¦bÃÒ¥æ©Ò¤½§i°Ï"´î¸ê¤½§i"¬°¨C¤é¬d¸ß¤§¤@¶µ
¸ô®|:
http://www.twse.com.tw/docs1/data01/market/public_html/b9912.txt
Sub Macro1()
For I = 1 To 12
If I < 10 Then
M = "0" & I
Else: M = I
End If
RD = "99" & M
MsgBox RD
Sheets("´î¸ê¬d¸ß").Select
Range("A1").Select
With Selection.QueryTable
.Connection = _
"URL;http://www.twse.com.tw/docs1/data01/market/public_html/b" & RD & ".txt"
.WebSelectionType = xlEntirePage
.WebFormatting = xlWebFormattingNone
.WebPreFormattedTextToColumns = True
.WebConsecutiveDelimitersAsOne = True
.WebSingleBlockTextImport = False
.WebDisableDateRecognition = False
.WebDisableRedirections = False
.Refresh BackgroundQuery:=False
End With
Next I
End Sub
¦ý¬OÃÒ¥æ©Ò¤½§i°ÏÃö©ó"´î¸ê¤½§i"±Ä¤ë¥÷¬d¸ß¤è¦¡
·í¨C¤ëªì©|µL¸ê®Æ®É«h·|¥X²{¿ù»~°T®§¦Ó¤¤Â_¬d¸ß¤u§@
¨Ò¦p¤µ¦~(99)4,5¤ëµL¸ê®Æ
¾ú¥v¬d¸ß§Y·|¥X¿ù¦Ó¤¤Â_
¨ä¹ê¨C¤ë¤@¶}©l©|µL·s¸ê®Æ®É³£·|¤¤Â_!!
½Ð°Ý¦³¤èªkÅý·í¤ë©|µL¸ê®Æ®É ºô¸ô¬d¸ß¯à°»´ú¨ì ¦Ó¤£·|¤¤Â_¨ä«á¤u§@¤èªk¶Ü? |
|
|
|
|
|
|