I need to edit a .csv file which is generated from another program.
What I do now is have a DOS batch file which runs the program to generate the file then opens the file in excel.
I then manually run a macro to format/sort the data.
How can I automate the step to run the macro?
Wasn't there at one time a commandline switch to specify a macro?
Any help would be appreciated.