|
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 |