How to select last week through Macro ?

[suniljain]

Suppose my current week is 36 . I want to select last week through macro.

week field is WORK_WEEK.

[#2]

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

[suniljain]

done

ActiveDocument.Fields(

"WORK_WEEK"). Select ActiveDocument.Evaluate("LastWeek"

)

[tresesco]

Hi,

I would prefer Trigger for the same. Its good to avoid macro !