Handicapping With VBA

[Roscoe_Word]

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.

Sheets("Test Sheet 1").Select
    Rows("1:4").Select
    Selection.Delete Shift:= xlup
    Range("A5").Select

    ActiveWorkbook.Close   SaveChanges: = true

...and then have that procedure repeat for all files in the folder. (Test Folder)

Thanks for any possible help.

[Roscoe_Word]

Never mind, fellas. I figured it out. Thanks.

[oilcountry99]

What's the solution you came up with, it may help others. Glad you figured it out

[mikeanite]

they actually teach this in business

[a4u2fear]

they actually teach this in business

really? cool. i had to learn it myself. i started many years ago teaching myself how to build a poker program to track %s. i did however have to take some college computer programming classes that i hated, but i really liked VBA

[Waterstpub87]

really? cool. i had to learn it myself. i started many years ago teaching myself how to build a poker program to track %s. i did however have to take some college computer programming classes that i hated, but i really liked VBA

I write in VBA every day at work. Fix code, write new code. In college had a few classes that use VBA. If you want a finance job, starting to become a requirement.