Part 3 of the VBA course will teach you advanced VBA constructs, such as classes and add-ins, database-enabled web publishing and integration with Python.
No starting dates
Starting date to be confirmed
- Duration: 5 weeks (unconfirmed)
- Fees: £560 (unconfirmed)
- Location: Online (unconfirmed)
Visual Basic for Applications (VBA) in Excel, Building Applications Part 3 Course overview
Master advanced VBA techniques over just 10 weeks with part 3 of the course, taught by an experienced VBA specialist.
VBA in Excel Part 3 includes customisation features such as classes and Add-ins, database-enabled web publishing, integrating Excel VBA with functionality from other applications and Ribbon adaptation.
You will write complex, structured programs leading up to a large-scale working application.
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.
Find out more about our Computer science and computing courses
This practical short course takes the form of a series of evening classes taking place once a week.
City Short Courses follow the academic year, delivering courses over three terms. These include:
- Autumn - October
- Spring - January
- Summer - April
- Delivered by an industry professional
- Taught in small groups
- Awarded a City, University of London certificate
What will I learn?
- 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
- Working with XML
- User Forms
Assessment and certificates
You will be awarded an official City, University of London certificate if you attend over 70 per cent of the classes. The course is not formally accredited.
There is no formal assessment as part of this short course.
Successful completion of Visual Basic for Applications (VBA) in Excel Part 2 or knowledge of subjects therein.
Applicants must be proficient in written and spoken English.