Prev: Permissions set on Word files differ from other permissions
Next: Track Changes
From: Terry Kinnard on 12 Mar 2010 11:51
I want to be able to calculate a new date 1 year ahead of a date that is
stored or entered in a bookmark so that if the value under the bookm ark
changes the calculated date value will also change. In Excel I can easily do
date calculation but if it's available in Word help is NO help.
From: Steve Yandl on 12 Mar 2010 12:15
Terry,

See if something like this would work.

Sub DateReCalc()
Dim strOldDate As String
Dim dteNewDate As Date

strOldDate = ActiveDocument.Bookmarks("origDate").Range.Text
dteNewDate = DateAdd("yyyy", 1, DateValue(strOldDate))

MsgBox dteNewDate

End Sub

Steve Yandl


"Terry Kinnard" <TerryKinnard(a)discussions.microsoft.com> wrote in message
news:CA30F924-7FA8-400E-80EC-0CF24350FC57(a)microsoft.com...
> I want to be able to calculate a new date 1 year ahead of a date that is
> stored or entered in a bookmark so that if the value under the bookm ark
> changes the calculated date value will also change. In Excel I can easily
> do
> date calculation but if it's available in Word help is NO help.

From: Doug Robbins - Word MVP on 12 Mar 2010 17:48
See fellow MVP Macropot's Word Date Calculation Tutorial at:

http://lounge.windowssecrets.com/index.php?showtopic=249902

Or

http://www.gmayor.com/downloads.htm#Third_party


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

"Terry Kinnard" <TerryKinnard(a)discussions.microsoft.com> wrote in message
news:CA30F924-7FA8-400E-80EC-0CF24350FC57(a)microsoft.com...
> I want to be able to calculate a new date 1 year ahead of a date that is
> stored or entered in a bookmark so that if the value under the bookm ark
> changes the calculated date value will also change. In Excel I can easily
> do
> date calculation but if it's available in Word help is NO help.

 | 
Pages: 1
Prev: Permissions set on Word files differ from other permissions
Next: Track Changes