What is VBA?
Visual Basic is an object-oriented programming language developed by Microsoft. Using Visual Basic makes it fast and easy to create type-safe
Who is it for?
This advanced short course builds on Visual Basic for Applications (VBA) in Excel Part 2, introducing a wider range of objects and applying previously learnt programming constructs to more complex and robust programs
Eligibility
Successful completion of Visual Basic for Applications (VBA) in Excel Part 2 or knowledge of subjects therein.
Course contents
- Review: the Excel API; loops; control structures; arrays; subroutines and functions
- Interacting with other applications such as MS Word and MS Access
- Providing Help documentation for the user of the spreadsheet application
- Manipulating data in conjunction with databases, using ADO
- Parsing and publishing data over the Internet
- Class modules
- Add-ins
- Working with XML
- User Forms
