Excel VBA Programming

Westminster College

Training

In London

£ 1,199 VAT inc.

The best Excel courses

See all

See all

Description

  • Type

    Training

  • Level

    Advanced

  • Location

    London

  • Duration

    3 Days

  • Start date

    Different dates available

See our website www.wcc.co.uk
See our website www.wcc.co.uk
See our website www.wcc.co.uk
See our website www.wcc.co.uk

Facilities

Location

Start date

London
See map
117 Waterloo Road, London Se1 8ul, SE1 8UL
Timetable: Wed/Thu/Fri

Start date

Different dates availableEnrolment now open

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Programmer
  • Analytic Expert

Teachers and trainers (1)

Dr Aras Arasilango

Dr Aras Arasilango

Academic Director

Course programme

Introduction to Excel VBA Programming
  • Understanding Macros
  • The Visual Basic Editor
  • Excel VBA Fundamentals
  • Variables, Data types, and Constants
  • VBA Procedures: Sub routines and functions
  • Decision Making with VBA
  • Repeating Actions in VBA
  • Working with Arrays
  • Working with Collections

Manipulating Files & controlling Other Applications with VBA
  • Manipulating Files and Folders with VBA
  • Controlling Other Applications with VBA
  • Using Excel with Microsoft Access

Enhancing the User Interface
  • Dialog Boxes and Custom Forms
  • Creating Custom Menus and Toolbars with VBA
  • Event-Driven Programming

Working with Local and Remote Databases
  • Exporting Data to Access Databases
  • Importing Data from Access Database
  • Connecting to Oracle / SQL Server databases
  • Reading data from Oracle/SQL Server databases
  • Exporting Excel Data to Remote Databases

Programming Special Features
  • Programming Pivot Tables and PivotCharts
  • Programming Special Features
  • Using and Programming Excel Lists
  • Programming the Visual Basic Editor

Excel and Web Technologies
  • HTML Programming and Web Queries
  • Excel and ASP
  • Using VBA to send mail
Programming C# for VBA
  • Creating Class Library project
  • Writing Classes
  • Creating DDL/TLB files
  • Using DDL/TLB files in VBA

Additional information

001

See related categories

Excel VBA Programming

£ 1,199 VAT inc.

The best Excel courses

See all

See all