- ©«¤l
- 8
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 9
- ÂI¦W
- 0
- §@·~¨t²Î
- wiinXP
- ³nÅ骩¥»
- 1.2.8.1
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2014-2-24
- ³Ì«áµn¿ý
- 2014-3-18
|
½Ð°Ý°ª¤â:)
°ò©óì¬d¸ßµ{¦¡WebQ000µ{¦¡
§Ú¤S¼g¤F¤@Ӧ۰ʤÀ¶ªºµ{¦¡Addpage000
·Q¹ê²{
1.¨Ì¦W³æ"list"¦Û°Ê²£¥Í"ªÑ¸¹§O"¤À¶
2.°»´ú¬°¨C¤À¶ªÅ¥Õ«á¦Û°Ê¶K¤W¸ê®Æ
½Ð°Ý¬Oþ¸Ì¥X¤F¿ù?
¥i§_«üÂI¤@¤U~?
-------------------------
Sub Addpages000() 'OKªº¦Û°Ê¤À¶
Dim ii, yy 'ii¦Û°Ê¼Ælist yy¦~/¤ë
Dim stock 'stockªÑ¸¹»Pªí¦W
Dim ptxt As String '³s½u¥Î
ii = 2 '°_©l
yy = 103 / 1 '¥ý¥Î©w¼Æ
Do While Worksheets("list").Cells(ii, 1) <> ""
stock = Worksheets("list").Cells(ii, 1)
Worksheets.Add
ActiveSheet.Name = stock
Application.Wait Now + TimeValue("00:00:01") 'wait 1s
ii = ii + 1
Loop
End Sub
Sub WebQ000() 'OKªººô¸ô¬d¸ß
Dim ptxt As String
Dim yy, stock
Dim ii
ii = 2
yy = 103 / 1
stock = Worksheets("list").Cells(ii, 1)
If Worksheets("list").Cells(ii, 1) = 0 Then
Worksheets(ii).Selection
ActiveSheet.QueryTables.Add Connection:="URL;", Destination:=Range("A1")
.Connection = "URL;http://www.otc.org.tw/ch/emergingstock/single_historical/result.php"
.PreserveFormatting = False
.WebSelectionType = xlEntirePage
.WebFormatting = xlWebFormattingNone
.WebDisableDateRecognition = True
.PostText = "ajax=true&input_month=" & yy & "&input_emgstk_code=" & stock
.Refresh False
Application.Wait Now + TimeValue("00:00:01") 'wait 1s
ii = ii + 1
Else: Exit Sub
End If
-----------------------------------------------
test004¦Û°Ê¤À¶Àx¦s.rar (14.86 KB)
|
|