|
Option Explicit
Sub test()
Dim strFileName$, strPath$, Rng As Range, wksName$
Application.ScreenUpdating = False
Set Rng = [A1].CurrentRegion
wksName = ActiveSheet.Name
strPath = ThisWorkbook.Path & "\项目合集\"
strFileName = Dir(strPath & "*.xls*")
Do Until strFileName = ""
If strFileName <> ThisWorkbook.Name Then
With Workbooks.Open(strPath & strFileName)
If isWksExists1(wksName) Then
With .Sheets(wksName)
.UsedRange.Clear
Rng.Copy .[A1]
End With
.Close True
Else
.Close False
End If
End With
End If
strFileName = Dir
Loop
Set Rng = Nothing
Application.ScreenUpdating = True
Beep
End Sub
Public Function isWksExists1(wksName As String) As Boolean
On Error Resume Next
isWksExists1 = Sheets(wksName).Name = wksName
End Function
|
|