Working with Workbooks
Open a Workbook
Workbooks.Open “C:\Reports\Sales.xlsx”
Save Workbook
ActiveWorkbook.Save
Close Workbook
ActiveWorkbook.Close
Use actual file paths appropriate to your computer. Avoid hard-coding personal paths in reusable projects.
User Forms
A UserForm provides a graphical interface for entering or selecting information.
Typical controls include:
- TextBox
- Label
- ComboBox
- ListBox
- CheckBox
- OptionButton
- CommandButton
Example
An employee entry form can contain:
Employee Name: [____________]
Department: [Sales ▼]
Salary: [____________]
[ Save ]
Practice
Design a basic Employee Data Entry UserForm