![]() |
#3
|
||||
|
||||
![]()
Hi Matthew,
Try: Code:
Sub NextYear() With ActiveDocument.Range With .Find .ClearFormatting .Text = "[0-9]{1,2}/[0-9]{1,2}/[0-9]{2,4}" .Replacement.Text = "" .Forward = True .Wrap = wdFindStop .MatchCase = False .MatchWholeWord = False .MatchWildcards = True .MatchSoundsLike = False .MatchAllWordForms = False .Execute End With Do While .Find.Found If Split(.Text, "/")(2) = Format(.Text, "yyyy") Then .Text = DateAdd("yyyy", 1, .Text) Else .Text = Format(DateAdd("yyyy", 1, .Text), "mm/dd/yy") End If .Collapse wdCollapseEnd .Find.Execute Loop End With End Sub
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Automatically update web images on Powerpoint | thetodd14 | PowerPoint | 0 | 05-04-2011 10:37 AM |
![]() |
Jamal NUMAN | Word | 2 | 01-06-2011 02:43 PM |
Letter Head Template - Update all other templates automatically | nirok | Word | 1 | 11-25-2010 03:14 PM |
![]() |
tkelly5446 | Project | 1 | 11-17-2010 04:26 AM |
Automatically update text changes in Word - how do I do it? | jonrm | Word | 2 | 05-21-2009 08:49 AM |