Objectives

• To extend the function written in exercise INT011

• To write an Excel document based on a template

• To format the output written to the Excel document

To achieve the objective you will complete the following:

• Step 1. Create RDMLX function iiiFN13
• Step 2. Complete Function iiiFN13
• Step 3. Create Form iiiFRM07 and test
• Step 4. Add ADD Command to Format Output

• Step 5. Format Start Date Column

• Step 6. Insert a Total Salary Formula
• Step 7. Password Protect the Document
• Summary

Before You Begin

You must have Microsoft Excel or the Excel Viewer installed to complete this exercise.