Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Sub GetSheets()
- Path = "C:\FILE PATH\"
- Filename = Dir(Path & "*.xlsx")
- Do While Filename <> ""
- Workbooks.Open Filename:=Path & Filename, ReadOnly:=True
- For Each Sheet In ActiveWorkbook.Sheets
- Sheet.Copy After:=ThisWorkbook.Sheets(1)
- Next Sheet
- Workbooks(Filename).Close
- Filename = Dir()
- Loop
- End Sub
Advertisement
Add Comment
Please, Sign In to add comment