Make date automatically update microsoft word

#Make date automatically update microsoft word how to#
#Make date automatically update microsoft word mod#
#Make date automatically update microsoft word code#

'Hard-Working Programmer' wrote in message for the late response. Months = DateDiff('m', Birthdate, Date) - Years * 12ДЄgedays = ' and ' & Format(Days) & ' days.'ДЄgedays = ' and ' & Format(monthdays$(Monthnow) - Birthday + Day) & ' days.'ДЄge = Format(Years) & ' years, ' & Format(Months) & ' Months' & AgedaysДЄctiveDocument.Tables(1).Cell(1, 3).Range.Text = Age Years = DateDiff('yyyy', Birthdate, Date) Set Birthrange = ActiveDocument.Tables(1).Cell(1, 2).Range I originally thought Word would update the date on open and/or close/re-open using the following coding, but I now believe I was wrong.

#Make date automatically update microsoft word mod#

If ((Yearnow Mod 4 = 0 And Calyear Mod 400 = 0) Or (Calyear Mod 4 = 0 And Calyear Mod 100 0)) Then However, that set of field codes probably will not be updated automatically by Word when you open the document, so the user would need to select the field codes and press F9. ' based on a birthdate entered in cell A2 and insert the ' a Macro to calculate the age in years, months and days Here's an eleven year's old macro that could be used to do it (though I am sure that I could improve on it if I was to do the same thing now: Set the Update Automatic Links At Open check box as. The advanced options of the Word Options dialog box. Scroll through the available options until you see the General section. Do read the document's introductory material. In Word 2010 and later versions display the File tab of the ribbon and then click Options.) At the left side of the dialog box click Advanced.

#Make date automatically update microsoft word code#

The above code is based on the item titled 'Interactively Calculate A PersonвЂ™s Age'.

#Make date automatically update microsoft word how to#

Plus, the code is for an ordinary field - you don't use a formfield.ДЇor information on how to do just about everything else you might want to do with dates in Word, check out my Microsoft Word Date Calculation Tutorial, at: If anyone can provide a counter-example, then the assumption is wrong, the field coding will need to change, and will probably need to be locale-dependent.') for the above example are created via Ctrl-F9 - you can't simply type them or copy & paste them from this message. NB, this also relies on the assumption that Word always correctly recognises the month and day when you specify a date in the format 'YYYY-MM-DD', regardless of the locale, in other words that '' is always recognised as 01 April 2016, never as 04 January 2016. 'year-(a maximum of 12+32=44)', so it is always going to return a number larger than 12.ДЄpply the date format you want to 'result'. In the specific case described (add 1 day), you should be able to use the following field coding: field will treat as a calculation, i.e. Originally I thought Word would auto-update the DATE when you open or close/re-open the document, but further experiments suggest that even the second suggestion in here will not do that. Without VBA, the calculation is possible, but not straightforward, because the Word field language has very limited support for date-related operations.