VBA 6.0 VBScript
Full-featured integrated development environment (IDE) with IntelliSense, color coding, debugging, and Object Browser No IDE
Rich data typing; supports String, Integer, Byte, Boolean, Currency, Single, Double, Variant, and User Defined data types Variants only
Flexible forms package (Microsoft Forms 2.0) with complete ActiveX control support No forms package
Code modules, class modules, forms, Host Project modules (which expose host application events) No module context, no project context; the host implementation must manage all code
Projects support referencing other DLLs, OCXs, and VBA projects at design time All external component references must be performed programmatically with an inefficient CreateObject...As Object command
Supports add-ins Has no IDE in which to support add-ins
Supports ActiveX Designers Has no Project context in which to support ActiveX Designers
Early (V-Table) binding means better performance (up to five times faster than VBScript) Late binding only simplifies syntax (but increases debugging difficulty)
Substantial installation size (>10MB) Lightweight, small disk footprint (~2MB)
Must license through Microsoft for distribution Free distribution
Table 1 VBA's Advantages Over VBScript. VBA6 provides Outlook developers with many advantages over VBScript. Here are some of the more significant differences.