Couple of questions. Can you use the same name as the original when you save the report?
Is the task of formatting the reports already automated? or do you format them manually?
If the reports were prepared using a template, then there would be no need to format each report separately. Is this possible or am I missing something?
If you can use the same name and you already have a formatting macro, then you can simply open each rport, store the name in an array, format it, then read the array to save the formatted report.
Let me know if you think this would work and we'll take the next step.