|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
Sub lsc()
Dim mypath As String, myname As String, Dname As String, sh As Worksheet, i As Integer
Set sh = ActiveSheet
mypath = ThisWorkbook.Path
myname = ThisWorkbook.Name
Dname = Dir(mypath & "\*.xls*")
Application.ScreenUpdating = False
sh.UsedRange.Offset(1, 0).Clear
Do While Dname <> ""
If Dname <> myname Then
For i = 1 To Worksheets.Count
With GetObject(mypath & "\" & Dname)
.Sheets(i).UsedRange.Offset(1, 0).Copy sh.[A1048576].End(xlUp).Offset(1)
.Close False
End With
Next
End If
Dname = Dir
Loop
Application.ScreenUpdating = True
MsgBox "汇总完成,请查看!"
End Sub |
|