View Single Post
 
Old 09-04-2017, 01:27 PM
slaycock slaycock is offline Windows 7 64bit Office 2013
Expert
 
Join Date: Sep 2013
Posts: 255
slaycock is on a distinguished road
Default

Try the following

Code:
Sub UpdateMyTips()

Dim myNewTip As Long
Dim myOldTotal As Long
    
    myNewTip = CLng(ActiveDocument.Paragraphs(1).Range.Words(1).text)
    
    myOldTotal = CLng(ActiveDocument.Paragraphs(2).Range.Words(1).text)
    
   With ActiveDocument.Paragraphs(2).Range
   
        .Words(1).text = CStr(myNewTip + myOldTotal) & " "
        .InsertAfter text:=myNewTip & " " & Format(Now(), "DDDD, MMMM d, yyyy") & vbCrLf
    End With
    ActiveDocument.Paragraphs(1).Range.text = " " & vbCrLf
End Sub
Reply With Quote