Hello Forum Crew.
Would anyone know how to do the following?
I need to open the 1st file in a folder. (.xlsm)
C:\Users\glenn\desktop\Test Folder
Then I could just do some random stuff.
...and then have that procedure repeat for all files in the folder. (Test Folder)Code:Sheets("Test Sheet 1").Select Rows("1:4").Select Selection.Delete Shift:= xlup Range("A5").Select ActiveWorkbook.Close SaveChanges: = true
Thanks for any possible help.