|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
- Set SH1 = Sheets("商品店铺榜")
- SH1.Range("A13:L1048576").ClearContents
-
- Pathinstr = "" & SH1.Cells(3, 3).Value & "" & SH1.Cells(3, 2).Value & ".xls"
-
- FileArr = FileAllArr(ThisWorkbook.Path, "*.xls?", ThisWorkbook.Name, True, False)
- For I = 0 To UBound(FileArr)
- If InStr(FileArr(I), Pathinstr) > 0 Then
- Str_coon = "HDR=yes';Data Source =" & FileArr(I) '//OFFICE2003,2007 通用
- StrSQL = "SELECT 来源,UV,占比 FROM [Sheet1$] WHERE 1=1"
- StrSQL = StrSQL & " AND 类别='" & SH1.Cells(10, 1).Value & "'"
- StrSQL = StrSQL & " AND 渠道='PC'"
- If Len(SH1.Cells(3, 5).Value) > 0 Then StrSQL = StrSQL & " AND 日期=#" & Format(SH1.Cells(3, 5).Value, "yyyy-MM-dd") & "#"
- StrSQL = StrSQL & " ORDER BY UV DESC"
- ' MsgBox StrSQL
- SQLARR = GET_SQL_To_Arr(StrSQL, Str_coon, False)
- SH1.Range("A13").Resize(UBound(SQLARR, 1) + 1, UBound(SQLARR, 2) + 1) = SQLARR
-
- StrSQL = "SELECT 来源,UV,占比 FROM [Sheet1$] WHERE 1=1"
- StrSQL = StrSQL & " AND 类别='" & SH1.Cells(10, 1).Value & "'"
- StrSQL = StrSQL & " AND 渠道='无线'"
- If Len(SH1.Cells(3, 5).Value) > 0 Then StrSQL = StrSQL & " AND 日期=#" & Format(SH1.Cells(3, 5).Value, "yyyy-MM-dd") & "#"
- StrSQL = StrSQL & " ORDER BY UV DESC"
- SQLARR = GET_SQL_To_Arr(StrSQL, Str_coon, False)
- SH1.Range("H13").Resize(UBound(SQLARR, 1) + 1, UBound(SQLARR, 2) + 1) = SQLARR
- End If
- Next I
复制代码 |
|