P
Petar Popara
I need MS Word macro that shows date: today + 30 days. Is it hard to do?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
H
Howard Kaikow
Look up "DateTime" in the Object Browser.
K
Karl E. Peterson
Petar said:I need MS Word macro that shows date: today + 30 days. Is it hard to
do?
About as simple as they come...
Public Function NowPlus30() As Date
NowPlus30 = Now + 30
End Function
If you don't want it *exactly* +30, but just want the date, you can modify it like:
Public Function TodayPlus30() As Date
TodayPlus30 = DateValue(Now + 30)
End Function
Later... Karl
G
George Nicholson
Selection.TypeText Text:=Format(DateAdd("d", 30, Now()), "mmmm dd, yyyy")
The DateAdd function adds 30 days to today
The Format function handles how the resulting date/time value is displayed.
HTH,
The DateAdd function adds 30 days to today
The Format function handles how the resulting date/time value is displayed.
HTH,
P
Petar Popara
Thank you all.
Is there a way to put macro in the middle of Word text and then just to open
Word doc, run macro once and it will enter new date in 5 locations in my
doc?
Is there a way to put macro in the middle of Word text and then just to open
Word doc, run macro once and it will enter new date in 5 locations in my
doc?
J
Jef Gorbach
havent looked, but suspect you could adapting the previous answers as an
insert fieldcode in each location??
insert fieldcode in each location??
P
Petar Popara
What does it mean "insert fieldcode"? How can i do that? Where in the menu
is it?
Thank you very much.
is it?
Thank you very much.