Visual Basic for Applications (VBA) in Excel, Building Applications | Part 3

City University London
Course summary
5 weeks
560 GBP
Part time
Next available date: 02/05/2020 - London
Open / Scheduled
Visual Basic for Applications (VBA) in Excel, Building Applications | Part 3

Course description

Visual Basic for Applications (VBA) in Excel, Building Applications | Part 3

For those who have successfully completed Visual Basic for Applications in Excel, Part 2 or have equivalent knowledge.

Part 3, Building Applications, includes customisation features such as classes and Add-ins, database-enabled web publishing, integrating Excel VBA with functionality from other applications and Ribbon adaptation.

In the process, you will write complex, structured programs leading up to a large-scale working application.

Suitability - Who should attend?

Prerequisite knowledge

Successful completion of  Visual Basic for Applications (VBA) in Excel Part 2 or knowledge of subjects therein.

English requirements

You must be proficient in written and spoken English.

Training Course Content

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
  • Add-ins
  • Working with XML
  • User Forms

Get Inspired! Watch the Video

A short course is an excellent way to gain new expertise, advance skills or simply follow a passion. With courses in business, computing, writing, creative industries, languages and law there is something for everyone. Glimpse inside our short course community: hear from our industry-expert tutors and listen to students as they reflect on their learning experience.

About provider

City University London

City University London

City, University of London is a special place. With skill and dedication, we have been using education, research and enterprise to transform the lives of our students, our community and the world for a hundred years. We are proud of...

Read more and show all courses with this provider

Contact info

City University London

Northampton Square
EC1V 0HB London

 Show phone number

U.K. L&D Report: 2018 - Benchmark Your Workplace Learning Strategy

Are you curious about the L&D strategies of some of the U.K.'s top companies?

Find out what they're up to in findcourses.co.uk's second annual U.K. L&D Report!


Learn more

Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

Find more courses here