Task 4: Import Data from External File 

In this task, you will populate the Sales Report Template by recording a macro that imports data from an external text file, Historical Sales Data.txt. Also, your will edit this macro to handle errors using help resources. 

4.1 Import data using the ‘Import Past Data Macro Button’ 

R 1. in the Template, implement Function 2 as per the Project Brief’s requirements: 

• test the macro button and all other functionalities for accuracy 

• output must conform to the Style Guide standards 

R 2. save and store the Template in accordance with organisational requirements 

R 3. request feedback from the Sales Manager (Assessor) on the draft Template 

R 4. after the receipt of this feedback, modify your draft template in light of the feedback received. 

4.2 Ensure error handling in macros using external assistance 

R 1. research the “Run-time error ‘5’ Invalid procedure call or argument” error using help resources R 2. edit the Import_Past_Data macro: 

• apply the solution based on your research 

• at the top of your VBA code, add a comment which shows the source of their solution R 3. save and store the Template in accordance with organisational requirements.

Appendix