5 Replies Latest reply: Feb 7, 2011 11:39 AM by Dirk Groen RSS

    Macro to Actions Issue (Last 12 Months select )

      We are in process of migrating QV report from Version 8.2 to 9. When we move report to version 9, we want to eliminate macros as much as possible. So far I am able to produce desired behavior using "Actions" and removing macros. However I am having trouble in converting following macro to actions in version 9.

      sub Lock

      set y=ActiveDocument.GetField("Date")

      y.TOPSelect "Date",12

      end sub

      How do I make sure search string always selects last 12 months?