|
楼主 |
发表于 2020-2-16 20:31
|
显示全部楼层
按钮 3 哪个代码 用不了
Sub 按钮3_Click()
Dim brr(1 To 99999, 1 To 13)
Application.ScreenUpdating = False
Set FSO = CreateObject("scripting.filesystemobject")
Path = GetDirName("", "请选择数据源文件夹")
For Each f In FSO.getfolder(Path).Files
If InStr(f.Name, "2020春季学生信息总表") = 0 Then
Set WB = Workbooks.Open(f)
arr = WB.Sheets(1).[a2].CurrentRegion 'a2代表行数据除去标题
For i = 3 To UBound(arr)
m = m + 1
For j = 1 To 13
brr(m, j) = arr(i, j)
Next
Next
WB.Close False
End If
Next
If m Then
[a2].CurrentRegion.Offset(1).ClearContents 'a2代表行数据除去标题
[a2].Resize(m, 13) = brr
End If
Application.ScreenUpdating = True
MsgBox "导入完成!"
End Sub |
|