AIN3701
Assignment 2 2025
Detailed Solutions, References & Explanations
Unique number: 721274
Due Date: 13 June 2025
QUESTION 1
Question a.
Simple Step-by-Step Guide to Open Your Excel File and Copy the VBA Code
Into It:
How to Open the Bookings File and Add VBA Code
Step 1: Open the Excel File
1. Open Excel on your computer.
2. Click File > Open and browse to the file named:
Bookings_Feb_2024.xlsx
3. Once it opens, click File > Save As and save it as:
StudentNumber_Surname_Q1.xlsm
4. ✅Make sure to choose Excel Macro-Enabled Workbook (*.xlsm) as the file type.
Step 2: Open the VBA Editor
Terms of use
By making use of this document you agree to:
1. Press Alt + F11 on your keyboard. This opens the VBA Editor.
Use this document as a guide for learning, comparison and reference purpose,
Terms of use
Not to duplicate, reproduce and/or misrepresent the contents of this document as your own work,
By making use of this document you agree to:
document
Use this Fully accept the consequences
solely as a guide forshould you plagiarise
learning, reference,or and
misuse this document.
comparison purposes,
Ensure originality of your own work, and fully accept the consequences should you plagiarise or misuse this document.
Comply with all relevant standards, guidelines, regulations, and legislation governing academic and written work.
Disclaimer
Great care has been taken in the preparation of this document; however, the contents are provided "as is" without any express or
implied representations or warranties. The author accepts no responsibility or liability for any actions taken based on the
information contained within this document. This document is intended solely for comparison, research, and reference purposes.
Reproduction, resale, or transmission of any part of this document, in any form or by any means, is strictly prohibited.
Assignment 2 2025
Detailed Solutions, References & Explanations
Unique number: 721274
Due Date: 13 June 2025
QUESTION 1
Question a.
Simple Step-by-Step Guide to Open Your Excel File and Copy the VBA Code
Into It:
How to Open the Bookings File and Add VBA Code
Step 1: Open the Excel File
1. Open Excel on your computer.
2. Click File > Open and browse to the file named:
Bookings_Feb_2024.xlsx
3. Once it opens, click File > Save As and save it as:
StudentNumber_Surname_Q1.xlsm
4. ✅Make sure to choose Excel Macro-Enabled Workbook (*.xlsm) as the file type.
Step 2: Open the VBA Editor
Terms of use
By making use of this document you agree to:
1. Press Alt + F11 on your keyboard. This opens the VBA Editor.
Use this document as a guide for learning, comparison and reference purpose,
Terms of use
Not to duplicate, reproduce and/or misrepresent the contents of this document as your own work,
By making use of this document you agree to:
document
Use this Fully accept the consequences
solely as a guide forshould you plagiarise
learning, reference,or and
misuse this document.
comparison purposes,
Ensure originality of your own work, and fully accept the consequences should you plagiarise or misuse this document.
Comply with all relevant standards, guidelines, regulations, and legislation governing academic and written work.
Disclaimer
Great care has been taken in the preparation of this document; however, the contents are provided "as is" without any express or
implied representations or warranties. The author accepts no responsibility or liability for any actions taken based on the
information contained within this document. This document is intended solely for comparison, research, and reference purposes.
Reproduction, resale, or transmission of any part of this document, in any form or by any means, is strictly prohibited.
