|
Sub demo()
sh = Array("[中西藥$]", "[1$]", "[2$]", "[3$]")
Set conn = CreateObject("adodb.connection")
Set rs = CreateObject("adodb.recordset")
today = Format(Date, "\\M月d日") & ".xlsx"
ds = ThisWorkbook.Path & today
conn.Open "Provider=Microsoft.ACE.OLEDB.12.0;Extended Properties='Excel 12.0;HDR=yes';Data Source =" & ds
For i = 0 To UBound(sh)
sql = "select * from " & sh(i)
rs.Open sql, conn, 3, 3
If rs.RecordCount <> 0 Then
Sheets(i + 1).[a2:e1000].ClearContents
Sheets(i + 1).[a2].CopyFromRecordset rs
End If
rs.Close
Next
End Sub
祝順心,南無阿彌陀佛!
|
|