Computer Technology and Information Management

A to Z Course Index

Information Sessions

Certificate Programs

Transcripts

Course Locations

Concurrent Enrollment

Order a Catalog

Courses begin every month. A new edition of our catalog is published three times a year in early April, July and December.


Quick Enroll

Search

Advanced Excel Automation Using VBA

X408.6 (2 semester units in EECS)

Learn the essentials of working in the VBA coding environment. You study major VBA program control structures, function and sub creation, object events, how to build forms and use controls on forms and worksheets, debugging, and the coding of error handling routines. You also learn how to build interfaces to relational databases such as Oracle or MySQL using ADO technology. Additional topics you cover include the use of the Windows API and Excel's implementation of regular expressions.

Excel is ubiquitous in the world of personal computing, but the power of this application can more readily be harnessed by using VBA with Excel's object model. Students learn to create sophisticated applications capable of performing complex tasks in settings as diverse as engineering, physics, biotechnology, and finance. They learn how to use the VBA programming environment and language as well as how to build graphical user interfaces and manipulate Excel objects. By the conclusion of the course, students will have the tools to create sophisticated applications that increase productivity and allow complex data manipulation.

There are currently no sections open for enrollment.




Sections closed for enrollment

Tues. June 2, Redwood City

Quick Enroll

Search