Loop Macro to edit Date

Feb 19, 2014
Reaction score
I have a file containing multiple word documents. Each will contain the text "Month Year" (ex January 2014). I'd like the macro to open each file in folder and change the date to the previous month (compared to current) with proper year (i.e. December 2013 will become January 2014). As such the macro, if ran in 10 days, would change whatever month year combination to "February 2014".

Any help in this would be greatly appreciated. Thanks in advance

P.S. I didn't attach any code because the only avenue I thought of was to use the "Find & Replace" feature to do this but then looping though all the files in the folder/monthly changes necessary would limit that option.


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question