|
楼主 |
发表于 2015-11-23 19:22
|
显示全部楼层
谢谢捧场!
程序中的部分代码如下:
- Sub 福彩双色球按期数查询() '福彩双色球自定义按期数查询,根据A1单元格的值,灵活提取开奖期数
- Dim URL, irow, oDoc, r, i, j
- Dim bt, fbt
- irow = Cells(Rows.Count, 1).End(xlUp).Row + 2
- Range("A2:L" & irow).Clear
- Range("c1:e1").Clear
- Range("c1") = "福彩双色球历史开奖数据"
- bt = Array("期号", "开奖日期", "开奖号码", "", "投注金额(元)", "一等奖", "", "二等奖", "", "奖池")
- fbt = Array("注数", "奖金(元)", "注数", "奖金(元)")
- Range("a2").Resize(1, 10) = bt
- Range("f3").Resize(1, 4) = fbt
- Range("c3") = "红球"
- Range("d3") = "蓝球"
- Application.DisplayAlerts = False
- Range("c1:e1").Merge
- Range("a2:a3").Merge
- Range("b2:b3").Merge
- Range("c2:d2").Merge
- Range("e2:e3").Merge
- Range("f2:g2").Merge
- Range("h2:i2").Merge
- Range("j2:j3").Merge
- With Range("a1:j3")
- .HorizontalAlignment = xlCenter
- .VerticalAlignment = xlCenter
- End With
- Application.DisplayAlerts = True
- URL = "http://chart.cp.360.cn/kaijiang/ssq?lotId=220051&spanType=0&span=" & [a1] & "&r=0.033004044787958264#roll_132/"
- Set oDoc = CreateObject("htmlfile")
- With CreateObject("msxml2.xmlhttp")
- .Open "get", URL, False
- .send
- oDoc.body.innerHTML = StrConv(.responsebody, vbUnicode)
- End With
- Set r = oDoc.All.tags("table")(1).Rows
- For i = 2 To r.Length - 1
- For j = 0 To r(i).Cells.Length - 2
- Cells(i + 2, j + 1) = r(i).Cells(j).innerText
- Next j
- Next i
- Application.ScreenUpdating = False
- Range("a1:j" & i + 1).Columns.AutoFit
- Range("a2:j" & i + 1).Borders.LineStyle = 1
- Application.ScreenUpdating = True
- End Sub
- Sub 福彩双色球按期号查询() '福彩双色球自定义按期号查询,根据A1单元格的起止期号,灵活提取开奖期数
- Dim URL, irow, oDoc, r, i, j
- Dim bt, fbt, qzqh
- irow = Cells(Rows.Count, 1).End(xlUp).Row + 2
- Range("A2:L" & irow).Clear
- Range("c1:e1").Clear
- Range("c1") = "福彩双色球历史开奖数据"
- bt = Array("期号", "开奖日期", "开奖号码", "", "投注金额(元)", "一等奖", "", "二等奖", "", "奖池")
- fbt = Array("注数", "奖金(元)", "注数", "奖金(元)")
- Range("a2").Resize(1, 10) = bt
- Range("f3").Resize(1, 4) = fbt
- Range("c3") = "红球"
- Range("d3") = "蓝球"
- Application.DisplayAlerts = False
- Range("c1:e1").Merge
- Range("a2:a3").Merge
- Range("b2:b3").Merge
- Range("c2:d2").Merge
- Range("e2:e3").Merge
- Range("f2:g2").Merge
- Range("h2:i2").Merge
- Range("j2:j3").Merge
- With Range("a1:j3")
- .HorizontalAlignment = xlCenter
- .VerticalAlignment = xlCenter
- End With
- Application.DisplayAlerts = True
- qzqh = Range("a1") & "_" & Range("b1")
- URL = "http://chart.cp.360.cn/kaijiang/ssq?lotId=220051&chartType=undefined&spanType=3&span=" & qzqh & "&r=0.22158218082040548#roll_132/"
- Set oDoc = CreateObject("htmlfile")
- With CreateObject("msxml2.xmlhttp")
- .Open "get", URL, False
- .send
- oDoc.body.innerHTML = StrConv(.responsebody, vbUnicode)
- End With
- Set r = oDoc.All.tags("table")(1).Rows
- For i = 2 To r.Length - 1
- For j = 0 To r(i).Cells.Length - 2
- Cells(i + 2, j + 1) = r(i).Cells(j).innerText
- Next j
- Next i
- Application.ScreenUpdating = False
- Range("a1:j" & i + 1).Columns.AutoFit
- Range("a2:j" & i + 1).Borders.LineStyle = 1
- Application.ScreenUpdating = True
- End Sub
- Sub 福彩双色球按日期查询() '福彩双色球自定义按日期查询,根据A1单元格的起止日期值,灵活提取开奖期数
- Dim URL, irow, oDoc, r, i, j
- Dim bt, fbt, qzrq
- irow = Cells(Rows.Count, 1).End(xlUp).Row + 2
- Range("A2:L" & irow).Clear
- Range("c1:e1").Clear
- Range("c1") = "福彩双色球历史开奖数据"
- bt = Array("期号", "开奖日期", "开奖号码", "", "投注金额(元)", "一等奖", "", "二等奖", "", "奖池")
- fbt = Array("注数", "奖金(元)", "注数", "奖金(元)")
- Range("a2").Resize(1, 10) = bt
- Range("f3").Resize(1, 4) = fbt
- Range("c3") = "红球"
- Range("d3") = "蓝球"
- Application.DisplayAlerts = False
- Range("c1:e1").Merge
- Range("a2:a3").Merge
- Range("b2:b3").Merge
- Range("c2:d2").Merge
- Range("e2:e3").Merge
- Range("f2:g2").Merge
- Range("h2:i2").Merge
- Range("j2:j3").Merge
- With Range("a1:j3")
- .HorizontalAlignment = xlCenter
- .VerticalAlignment = xlCenter
- End With
- Application.DisplayAlerts = True
- qzrq = Format(Range("a1"), "yyyy-mm-dd") & "_" & Format(Range("b1"), "yyyy-mm-dd")
- URL = "http://chart.cp.360.cn/kaijiang/ssq?lotId=220051&chartType=undefined&spanType=2&span=" & qzrq & "&r=0.09021096024662256#roll_132/"
- Set oDoc = CreateObject("htmlfile")
- With CreateObject("msxml2.xmlhttp")
- .Open "get", URL, False
- .send
- oDoc.body.innerHTML = StrConv(.responsebody, vbUnicode)
- End With
- Set r = oDoc.All.tags("table")(1).Rows
- For i = 2 To r.Length - 1
- For j = 0 To r(i).Cells.Length - 2
- Cells(i + 2, j + 1) = r(i).Cells(j).innerText
- Next j
- Next i
- Application.ScreenUpdating = False
- Range("a1:j" & i + 1).Columns.AutoFit
- Range("a2:j" & i + 1).Borders.LineStyle = 1
- Application.ScreenUpdating = True
- End Sub
复制代码 |
|