|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
Sub limont()
Dim Cn As Object, StrSQL$, Path$, FileName$
Set Cn = CreateObject("Adodb.Connection")
Cn.Open "Provider=Microsoft.ACE.OLEDB.12.0;Extended Properties=Excel 12.0;Data Source=" & ThisWorkbook.FullName
Path = ThisWorkbook.Path & "\limonet\"
FileName = Dir(Path & "*.xlsx")
Do While FileName <> ""
StrSQL = StrSQL & " Union All Select * From [Excel 12.0;Database=" & Path & FileName & "].[项目表$A3:M] Where F4<>''"
FileName = Dir
Loop
Range("A2").CopyFromRecordset Cn.Execute(Mid(StrSQL, 12))
End Sub |
评分
-
2
查看全部评分
-
|