Loop Macro to Edit Date
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
|