Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Sub Merger()
- Dim bookList As Workbook
- Dim mergeObj As Object, dirObj As Object, filesObj As Object, everyObj As Object
- Application.ScreenUpdating = False
- Set mergeObj = CreateObject("Scripting.FileSystemObject")
- Set dirObj = mergeObj.Getfolder("Path") 'PATH
- Set filesObj = dirObj.Files
- For Each everyObj In filesObj
- Set bookList = Workbooks.Open(everyObj)
- Range("A2:IV" & Range("A65536").End(xlUp).Row).Copy 'A65536 is the last row for Colmn A
- ThisWorkbook.Worksheets(1).Activate
- Range("A65536").End(xlUp).Offset(1, 0).PasteSpecial
- Application.CutCopyMode = False
- bookList.Close
- Next
- End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement