|
Sub test() '木有附件,仅是猜测
Dim cn As Object, rs As Object, p$, f$, sq$, ar(1 To 5000, 0), n&
Set cn = CreateObject("ADODB.Connection")
Set rs = CreateObject("ADODB.Recordset")
cn.Open "Provider=Microsoft.ACE.OLEDB.12.0;Extended Properties='Excel 12.0;HDR=NO';Data Source=" & ThisWorkbook.FullName
p = ThisWorkbook.Path & "\"
f = Dir(p & "*.xls*")
Do While f <> ""
If f <> ThisWorkbook.Name Then
n = n + 1
sq = "SELECT * FROM [Excel 12.0;HDR=NO;Database=" & p & f & "].[报告$D6:D6]"
rs.Open sq, cn, 1, 3
ar(n, 0) = rs(0)
If rs.State = 1 Then rs.Close
End If
f = Dir
Loop
[c1].Resize(n) = ar
cn.Close
Set cn = Nothing
Set rs = Nothing
End Sub |
|