|
求助将不同EXCEL表合并总表 支持只读情况下合并
Sub pppp()
Application.ScreenUpdating = False
Dim Msg, Style, Title, Help, Ctxt, Response, MyString
Msg = "请确定数据无误!!" ' ﹚
Style = vbYesNo + vbCritical + vbDefaultButton2 ' ﹚vbExclamation
Title = "温馨提示!!" ' ﹚
Response = MsgBox(Msg, Style, Title) 'note
If Response = vbYes Then
Sheets("AA").Visible = True
Sheets("AA").Select
Rows("2:1048576").ClearContents
x = Range("BU1")
Set FS = CreateObject("Scripting.FileSystemObject")
Set f = FS.GetFolder(ThisWorkbook.Path & "\AAAAA\")
For Each F1 In f.subfolders
For Each FSFILE In F1.Files
Workbooks.Open (FSFILE)
aRow = Sheets(x).Range("1048576").End(xlUp).Row
tRow = ThisWorkbook.Sheets("AA").Range("1048576").End(xlUp).Row + 1
Sheets(x).Range("a4:bd" & aRow).Copy ThisWorkbook.Sheets("AA").Range("a" & tRow)
Workbooks(FSFILE.Name).Close False
Next FSFILE
Next F1
With ActiveSheet
End With
End If
Application.ScreenUpdating = True
End Sub |
|