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
-J
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.
Any help in this would be greatly appreciated. Thanks in advance
-J
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.