Visual Basic for Applications: Difference between revisions

Revision as of 00:01, 24 February 2023

Revision as of 12:56, 11 April 2023

Line 49:

==Version history==

* VBA was first launched with MS Excel 5.0 in 1993. It became an instant success among developers to create corporate solutions using Excel. Inclusion of VBA with Microsoft Project, Access and Word replacing AccessBASICAccess BASIC and [[WordBASICWord BASIC]] respectively made it more popular.

* VBA 4.0 is the next famous release with a totally upgraded version compared to previous one. Released in 1996, it is written in C++ and became an object oriented language.

* VBA 5.0 was launched in 1997 along with all of MS Office 97 products. The only exception for this was Outlook 97 which used [[VBScript]].

Line 56:

* Office 2010 includes VBA 7.0. There are no new features in VBA 7 for developers compared to VBA 6.5 except for 64-bit support. However, after VBA 6.5/Office 2007, Microsoft stopped licensing VBA for other applications.

* Office 2013, Office 2016, Office 2019 and Office 2021 include VBA 7.1.

==Development==