VBA in Excel, Building Applications Part 3

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.

Timetable

This practical short course takes the form of a series of evening classes taking place once a week.

City St George’s Short Courses follow the academic year, delivering courses over three terms. These include:

• Autumn - October
• Spring - January
• Summer - April

Benefits

• Delivered by an industry professional
• Taught in small groups
• Awarded a City St George’s, University of London certificate

• 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

You will be awarded an official City St George’s, University of London certificate if you attend over 70 per cent of the classes. The course is not formally accredited.

Assessment

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.

English requirements

Applicants must be proficient in written and spoken English.