[已解决]这个代码运行太慢了那位老师帮改下谢谢！

柔儿梦婷

表格内容少运行快，当达到15M以上运行起来太慢有时要等半个小时左右，但另外一个代码运行不会出现这种情况，应该说是这个代码有问题麻烦老师帮改下谢谢！
Sub abc()
    Range("A3:AC3500").Clear
    k3dshijihao = "http://www.17500.cn/getData/ssq.TXT"
    d3s = "WData3D_All"
    Cells(2, 1) = "开奖期号"
    Cells(2, 2) = "开奖日期"
    Cells(2, 3) = "红"
    Cells(2, 4) = "号"
    Cells(2, 5) = " "
    Cells(2, 6) = " "
    Cells(2, 7) = " "
    Cells(2, 8) = " "
    Cells(2, 9) = "蓝"
    Cells(2, 10) = "红"
    Cells(2, 11) = "号"
    Cells(2, 12) = "出"
    Cells(2, 13) = "球"
    Cells(2, 14) = "顺"
    Cells(2, 15) = "序"
    Cells(2, 16) = "投注总额"
    Cells(2, 17) = "奖池金额"
    Cells(2, 18) = "一等注数"
    Cells(2, 19) = "一等金额"
    Cells(2, 20) = "二等注数"
    Cells(2, 21) = "二等金额"
    Cells(2, 22) = "三等注数"
    Cells(2, 23) = "金额"
    Cells(2, 24) = "四等注数"
    Cells(2, 25) = "金额"
    Cells(2, 26) = "五等注数"
    Cells(2, 27) = "金额"
    Cells(2, 28) = "六等注数"
    Cells(2, 29) = "金额"
    cz = k3dshijihao: czmc = d3s
    With ActiveSheet.QueryTables.Add(Connection:="TEXT;" & cz, Destination:=Range("A3"))
        .Name = czmc
        .FieldNames = True
        .RowNumbers = False
        .FillAdjacentFormulas = False
        .PreserveFormatting = True
        .RefreshOnFileOpen = False
        .RefreshStyle = xlInsertDeleteCells
        .SavePassword = False
        .SaveData = True
        .AdjustColumnWidth = True
        .RefreshPeriod = 0
        .TextFilePromptOnRefresh = False
        .TextFilePlatform = xlWindows
        .TextFileStartRow = 1
        .TextFileParseType = xlDelimited
        .TextFileTextQualifier = xlTextQualifierDoubleQuote
        .TextFileConsecutiveDelimiter = True
        .TextFileTabDelimiter = False
        .TextFileSemicolonDelimiter = False
        .TextFileCommaDelimiter = False
        .TextFileSpaceDelimiter = True
        .TextFileColumnDataTypes = Array(1, 2, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1)
        .TextFileTrailingMinusNumbers = True
        .Refresh BackgroundQuery:=False
    End With
    Range("A" & (Application.Count(Range("a1:a3000")))).Select
    End
End Sub

最佳答案

月排行榜 / 总排行榜

zjdh

2015-4-17 19:44

Sub abc2() '简化一下
    Range("A3:AC3500").Clear
    cz = "http://www.17500.cn/getData/ssq.TXT"
    Cells(2, 1).Resize(1, 29) = Array("开奖期号", "开奖日期", "红", "号", " ", " ", " ", " ", "蓝", "红", _
      "号", "出", "球", "顺", "序", "投注总额", "奖池金额", "一等注数", "一等金额", "二等注数", "二等金额", _
      "三等注数", "金额", "四等注数", "金额", "五等注数", "金额", "六等注数", "金额")
    With ActiveSheet.QueryTables.Add(Connection:="TEXT;" & cz, Destination:=Range("A3"))
        .TextFileSpaceDelimiter = True
        .TextFileColumnDataTypes = Array(1, 2, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1)
        .Refresh
    End With
    Range("A65536").End(3).Select
End Sub

速度缘由网速！！

跳转到最佳答案楼层

liu-aguang

代码固然不很简洁,但不是影响速度的主因;问题应该是当时网速太慢.

zjdh

Sub abc2() '简化一下
    Range("A3:AC3500").Clear
    cz = "http://www.17500.cn/getData/ssq.TXT"
    Cells(2, 1).Resize(1, 29) = Array("开奖期号", "开奖日期", "红", "号", " ", " ", " ", " ", "蓝", "红", _
      "号", "出", "球", "顺", "序", "投注总额", "奖池金额", "一等注数", "一等金额", "二等注数", "二等金额", _
      "三等注数", "金额", "四等注数", "金额", "五等注数", "金额", "六等注数", "金额")
    With ActiveSheet.QueryTables.Add(Connection:="TEXT;" & cz, Destination:=Range("A3"))
        .TextFileSpaceDelimiter = True
        .TextFileColumnDataTypes = Array(1, 2, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1)
        .Refresh
    End With
    Range("A65536").End(3).Select
End Sub

速度缘由网速！！

柔儿梦婷

zjdh 发表于 2015-4-17 19:44
Sub abc2() '简化一下
    Range("A3:AC3500").Clear
    cz = "http://www.17500.cn/getData/ssq.TXT" ...

非常感谢现在快多了1分钟就完成了谢谢！