Running a macro on all open worksheets.
Posted by Chris B on August 10, 2001 11:54 AM
I have a a BUNCH of csv files that need to be reformatted for use by another program. I have a macro that does this manipulation perfectly! What I am looking for is a way to either run this macro on all csv files in a directory or I can open them, say 50 at a time, and then run my reformat macro. Also, this method would need to save and close each csv file once it was done. Thanks Chris