1. #1
    Roscoe_Word
    Roscoe_Word's Avatar Become A Pro!
    Join Date: 02-28-12
    Posts: 1,620
    Betpoints: 4136

    Handicapping With VBA

    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.

    Code:
    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.

  2. #2
    Roscoe_Word
    Roscoe_Word's Avatar Become A Pro!
    Join Date: 02-28-12
    Posts: 1,620
    Betpoints: 4136

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

  3. #3
    oilcountry99
    oilcountry99's Avatar SBR PRO
    Join Date: 08-29-10
    Posts: 499
    Betpoints: 3469

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

  4. #4
    mikeanite
    mikeanite's Avatar Become A Pro!
    Join Date: 04-13-10
    Posts: 473
    Betpoints: 528

    they actually teach this in business

  5. #5
    a4u2fear
    TEASE IT
    a4u2fear's Avatar SBR PRO
    Join Date: 01-29-10
    Posts: 7,899
    Betpoints: 4046

    Quote Originally Posted by mikeanite View Post
    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

  6. #6
    Waterstpub87
    Life-Style Arbitrage
    Waterstpub87's Avatar SBR PRO
    Join Date: 09-09-09
    Posts: 3,284
    Betpoints: 12

    Quote Originally Posted by a4u2fear View Post
    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.

Top