ESSENTIALS OF VB AND VBA

ANIL MITRA PHD, 1998, REFORMATTED June 9, 2003

HOME | CONTACT

LEGEND: RED = COMPLETE AND OR REVIEW…


OUTLINE

1      EMPHASIS

2      TOPICS

2.1        Concepts

2.2        Language

2.3        Object Model - Objects, Methods and Properties

2.3.1        VB

2.3.2        Office VBA

2.4        Tasks - ENUMERATE AND SELECT

2.5        The Development Environment

2.6        Help

2.6.1        Learning and reference

2.6.2        Using help

2.6.3        Using the learning tools;

         using the Integrated Development Environment tools as learning tools

3      EXTENDING VISUAL BASIC

3.1        topics

3.2        References

4      LARGE PROJECTS

5      SMALL PROJECTS OR TASKS


ESSENTIALS OF VB AND VBA

1      EMPHASIS

Stand alone and integrated applications

For MS Office

Programming and extension to other languages and methods including computer science

Integration with MS DOS, Windows 95,  Access

2      TOPICS

2.1       Concepts

Event driven programs

Object oriented programming and programming languages

The Visual format...

2.2       Language

2.3       Object Model - Objects, Methods and Properties

2.3.1    VB

2.3.2    Office VBA

Office

Word

Excel

Access

Access DAO, RDO, ODBC

PowerPoint

2.4       Tasks - ENUMERATE AND SELECT

Standard

Typical

Specialized: What are my needs?

2.5       The Development Environment

Macro Recorder, Modules and Macros, Immediate/Locals/Watch windows, Object Browser

Auto-Complete, De-bugging tools...

2.6       Help

2.6.1    Learning and reference

Books

Visual Basic Step by Step, Michael Halvorsen, 1997

Special Edition Using Visual Basic 5, Mike McKelvy, Ronald Martinsen and Jeff Webb, QUE, 1997

Advanced Books

Advanced Visual Basic 5, The Mandelbrot Set, 1997

Hardcore Visual Basic Version 5.0, Bruce McKinney, 1997

Online

Visual Basic Help

Visual Basic Books Online

Mastering Visual Basic 5

MSDN

2.6.2    Using help

2.6.3    Using the learning tools; using the Integrated Development Environment tools as learning tools

 

3      EXTENDING VISUAL BASIC

3.1       topics

Integrating DOS, Windows 95, Win32 API

Writing and using DLLs, using and modifying Win32 API

3.2       References

See section 2.6.1 above, Advanced Books

4      LARGE PROJECTS

5      SMALL PROJECTS OR TASKS

User interface

Multiple saves

View, manipulate and print directory tree

Tree uses and automation


ANIL MITRA | RESUME | HORIZONS ENTERPRISES™ | HOME | SITE-MAP | USEFUL LINKS | CONTACT
PHILOSOPHY OF MIND