以下是引用开辆小富康在2010-4-10 17:03:00的发言: Sub GetName() Dim F$ Dim Arr Dim Arr2() If MsgBox("运行程序前请保存关闭需要导入的EXCEL文件,准备好了吗?", vbYesNo) = vbNo Then Exit Sub Application.DisplayAlerts = 0 Application.ScreenUpdating = 0 F = Dir(ThisWorkbook.Path & "/" & "*.xls") Do If F <> ThisWorkbook.Name Then Workbooks.Open ThisWorkbook.Path & "\" & F With ActiveWorkbook.Sheets("Sheet1") r = .Range("D65536").End(xlUp).Row If r > 1 Then Arr = .Range("D2:J" & r) ReDim Arr2(1 To UBound(Arr), 1 To 4) For i = 1 To UBound(Arr) Arr2(i, 1) = Arr(i, 1): Arr2(i, 2) = Arr(i, 2) Arr2(i, 3) = Arr(i, 7): Arr2(i, 4) = F Next i With ThisWorkbook .Sheets("Sheet1").Range("a65536").End(xlUp).Offset(1, 0).Resize(UBound(Arr2), 4) = Arr2 End With End If End With ActiveWorkbook.Close False End If F = Dir() Loop While F <> "" Application.ScreenUpdating = 1 Application.DisplayAlerts = 1 End Sub
是这个意思吗?请解压文件夹以后运行。所有文件放在同一个文件夹下面。 麻烦,怎么用,导入后跳出个框,点击是后么反应~~ |