Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Suppose my current week is 36 . I want to select last week through macro.
week field is WORK_WEEK.
Hi Sunil,
if you wanna select current week first you must create a variable CurrentWeek (you can name it whatever you want): =week(Now()) . And the macro will be:
sub SelectWeek
set v = ActiveDocument.Variables("CurrentWeek")
ActiveDocument.Fields("WORK_WEEK").Select v.GetContent.String
end sub
Stefan
done
ActiveDocument.Fields(
"WORK_WEEK"). Select ActiveDocument.Evaluate("LastWeek")
Hi,
I would prefer Trigger for the same. Its good to avoid macro !