Hello there,
I am looking for some help with what I perceive as a fairly simple loop function.
I have a Mac OS file directory structured like this:
Teams->49ers->player-stats.csv
Teams->Bears->player-stats.csv
Teams->Bengals->player-stats.csv
What I am looking to do is formulate a script that will open each team's player-stats.csv file, sort columns left to right A-Z, and save the file afterwards.
1. Macro excel file column-sorter.xls lives in the Teams directory
2. I open the file and execute the macro
3. It navigates from Teams to 49ers to open file player-stats.csv
4. Perform a left to right sort on row 1 A to Z
5. Save and close the file
6. Repeat steps 3-5 for all 32 teams
I am not great with excel VBA, so I would appreciate the help as the mismatched column ordering has been a very frustrating blocker for my project. Thanks!
I am looking for some help with what I perceive as a fairly simple loop function.
I have a Mac OS file directory structured like this:
Teams->49ers->player-stats.csv
Teams->Bears->player-stats.csv
Teams->Bengals->player-stats.csv
What I am looking to do is formulate a script that will open each team's player-stats.csv file, sort columns left to right A-Z, and save the file afterwards.
1. Macro excel file column-sorter.xls lives in the Teams directory
2. I open the file and execute the macro
3. It navigates from Teams to 49ers to open file player-stats.csv
4. Perform a left to right sort on row 1 A to Z
5. Save and close the file
6. Repeat steps 3-5 for all 32 teams
I am not great with excel VBA, so I would appreciate the help as the mismatched column ordering has been a very frustrating blocker for my project. Thanks!
