Course Code:60.03
Course Subject:Excel Visual Basic for Applications
Course Title:Excel VBA Advanced
Aims:To provide the student with the knowledge and confidence to write Visual Basic Code in the Excel environment.
Introduction:Visual Basic for Applications is based on the very popular Visual Basic programming language. It provides a means of controlling an Excel application (Workbooks, Worksheets, Ranges and Cells). The key difference between VBA and Visual Basic is that VBA resides within Microsoft applications like Excel, Word, Visio etc. whereas Visual Basic is a standalone application. VBA code allows the programmer to implement functions and take control of Excel objects way beyond conventional Spreadsheet use. This course is intended to provide the student with the knowledge and ability to build on the topics covered in the Introduction and Intermediate level courses and use the more sophisticated features available in the Excel Visual Basic environment. This is an intensive course and prior knowledge of the basics of Visual Basic coding is required..
  

Objectives

The learner will be able to:

Assessment Criteria

The learner has achieved this objective because he/she can:

1. Use User Defined Data Types

  1. Create User Defined Types

  2. Work with User Defined Types

2. Read and Write Data from and to Files

  1. Access (Open and Close) Files

  2. Read and write Sequential Data

  3. Read and write Sequential Text files

  4. Read and write Sequential Data files

  5. Read and write Random files

  6. Read and write Sequential binary files

  7. Use Utility statements and functions

3. Work across Applications

  1. Access other applications

  2. Control other application objects

  3. Use Word Objects

  4. Use Visio Objects

  5. Use Access Objects

4. Use Dynamic Link Libraries (DLLs)

  1. Declare DLL functions

  2. Call DLL functions

  3. Pass User-defined types to DLLs

  4. Understand DLL results

  5. Access specific Windows with DLLs

  6. Understand different DLL function Data types