Computeractive

VBA macro Issue 716

Jul 11th, 2025
203
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.33 KB | None | 0 0
  1. Sub GetSheets()
  2. Path = "C:\FILE PATH\"
  3. Filename = Dir(Path & "*.xlsx")
  4. Do While Filename <> ""
  5. Workbooks.Open Filename:=Path & Filename, ReadOnly:=True
  6. For Each Sheet In ActiveWorkbook.Sheets
  7. Sheet.Copy After:=ThisWorkbook.Sheets(1)
  8. Next Sheet
  9. Workbooks(Filename).Close
  10. Filename = Dir()
  11. Loop
  12. End Sub
Advertisement
Add Comment
Please, Sign In to add comment