Post date: 09-May-2014 09:53:08
Desired Output:
Add a view generate date to keep track of the date a View (report) is built.
1. View Template:
- on A1, create formula
- C1 is a token [T.ReportBuildDate] , define cell name as “BuildDate” (this cell will be hidden using white font)
2. Workbook Script:
- Create a global workbook script “1_Page_Properties” (this can be reusable)
- Create prodecure “GenerateDate”
- Add method “CopyRange”
- Copy the value from “BuildDate” (from template)
3. Execute Procedure on View
- Create event “AfterBuild”
- Add method “Execute Prodecure”
- Select Prodecure “GenerateDate” (from step 3)
N