troubleshooting Question

How do I run a macro against multiple files

Avatar of sharringtoncpa
sharringtoncpaFlag for United States of America asked on
Microsoft DevelopmentMicrosoft Word
21 Comments1 Solution451 ViewsLast Modified:
I have a number of reports that are mainframe generated.  Once I receive the reports, I have to run a macro to reformat each of the files which changes the margins, line spacing, etc.  Currently, I have to open each file, then run the reformat macro and then save the new word file.  I would like to be able to run a macro or other code from outside the files.  I would like to be able to select each of the files that I want to run the reformat macro on and then also have the new reformatted files saved with a new name.  Each file contains the wording "Report  No." which is followed by the actual report name.  I would like to use the actual report name as the new filename for the reformatted files.  Any help would be appreciated.
Join our community to see this answer!
Unlock 1 Answer and 21 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 21 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros