I need a script to auto sort by specific column(s) and format every worksheet in an excel file
Posted on 2008-10-29
I am seeking a new .VBS script (please no VBA) for automation purposes that will take a specific excel spread sheet and sort all work sheets by a specific column(s). After the sorting is completed I need the script to also auto set the page to either letter or legal (also like to set portrait or landscape) and set the work sheets to auto fit to 1 page wide by any number of pages long, the # pages long doesnt matter much so long as it all fits on 1 page wide when printed.
I think that the lines for the choices should perhaps be a comment and just uncomment my choices manually with no actual prompting.
after all the work is done, the worksheet should be saved automatically.