之前下載一直下載雙色球的下載表，用新電腦下載使用的時候提示Refresh BackgroundQuery:=False，如何解決
以下是宏資料：
Private Sub CommandButton1_Click()
Range("A3:AC3500").Clear
k3dshijihao = "http://182.92.109.149/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
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
End Sub
轉載請註明出處，本文鏈接：https://www.uj5u.com/qita/40195.html
上一篇：小初學者請教，有大神能回答一下嗎
下一篇：RMarkdown錯誤