Visual Basic is a standalone tool for creating separate software components such as executable programs, COM components and ActiveX? Controls. It is useful when building a specialised solution from scratch. VBA offers the same powerful tools as Visual Basic in the context of an existing application and is the best option for customising software that already meets most needs. VBScript is a lightweight version of the Visual Basic language designed specifically for use on web pages. While apple Script can sometimes be used for simple automation, VBA is the premier technology designed specifically for application automation.