Thread: [Solved] Loop Macro to Edit Date
View Single Post
 
Old 02-19-2014, 07:11 AM
damaniam damaniam is offline Windows 7 64bit Office 2013
Novice
 
Join Date: Nov 2013
Posts: 18
damaniam is on a distinguished road
Default 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
Reply With Quote