Word Field Update

MANOHAR · #1 06-13-2018, 10:31 PM

How do we pragmatically find out that fields needs to be updated in the document before calling fields.Update()??

Thanks!

Guessed · #2 06-14-2018, 01:31 AM

Interesting question. I have no idea.

The only way I think you could tell is by updating the field and then comparing the result with the previous value.

MANOHAR · #3 06-14-2018, 02:03 AM

Thanks! Could you tell me how can I programmatically compare the result?

Guessed · #4 06-14-2018, 03:24 AM

Try this macro:

Code:

Sub FieldsUpdated()
  Dim aFld As Field, sBefore As String, sAfter As String
  Dim sMsg As String, iChangeCount As Integer
  For Each aFld In ActiveDocument.Fields
    sBefore = aFld.Result
    aFld.Update
    sAfter = aFld.Result
    If sBefore <> sAfter Then
      aFld.Result.HighlightColorIndex = wdDarkYellow
      iChangeCount = iChangeCount + 1
    End If
  Next aFld
  If iChangeCount > 0 Then
    MsgBox iChangeCount & " field(s) were changed. Look for the dark yellow highlights"
  Else
    MsgBox "No field changes"
  End If
End Sub

Charles Kenyon · #5 06-14-2018, 05:40 AM

Note, you probably want to run that on a copy of your document.

Stefan Blom · #6 06-17-2018, 04:06 PM

Out of curiosity, why do you want to know if a field has been updated? It won't do any harm to update it whenever you want to ensure that the display is up to date (even if the field is already displaying the updated result).

macropod · #7 06-17-2018, 07:18 PM

Cross-posted (and answered before posting here) at: https://social.msdn.microsoft.com/Fo...?forum=worddev
For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184

Manohar: This is the third time you've been asked in this forum to provide cross-post links. Consider this a final warning - cross-post again without providing links and your account will be terminated.

Thread closed.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Update & Unlink Specific Merge Field in Word Doc from Mail Merge - Excel VBA	RMerckling	Mail Merge	16	05-17-2018 05:19 PM
Force Word (2007) to only update date field when asked to	ShankedS	Word	5	10-25-2016 06:45 AM
Can field dynamically update?	namedujour	Word	2	03-04-2016 10:21 PM
VBA script to update field codes?	Calab	Word VBA	1	04-07-2014 09:27 PM
Auto update Filename field	Oliver Beirne	Word VBA	4	10-19-2012 03:33 AM