VBA enables users to create from simple macros up to more advanced applications. Microsoft may be moving away gradually from VBA and considering the adoption of JavaScript API for MS Office applications, including Office 360 and Office for macOS. However, there is a report that Microsoft is considering JavaScript API replacement. The inclusion of VBA in 2019 is significant proof that VBA is not outdated but still very much relevant. It was added to MS Office 2013, 2016, and 2019. VBA 7.1 came with new features and a major improvement. For reasons best known to the corporation, Microsoft stopped licensing and support for VBA after the VBA 6.5/MS Office 2007 release.įor close to three years, it seems VBA has been dropped and Microsoft is cooking another coding language until suddenly in 2010 when Microsoft released MS Office 2010 with VBA 7.0.Īlthough, no new features/significant changes were added/made for developers in VBA 7.0 compared to VBA 6.5 (except the support for 64-bit systems), the release counters the already-growing belief that VBA is outdated and going into extinction. MS Office XP was released with VBA 6.3, VBA 6.4 with MS Office 2003, and VBA 6.5 with MS Office 2007. The 6.2 version of VBA was launched together with MS Office 2000 SR-1. In 1999, both VBA 6.0 and VBA 6.1 were released with support for COM add-ins in MS Office 2000. In 1997, VBA 5.0 was released along with all of Microsoft Office 97 products, except MS Outlook 97, which still used VBScript. VBA 4.0 was written in C++ and became an object-oriented language. VBA 4.0 was the next popular version, released in 1996 with upgraded features compared to the earlier version. VBA was later added to MS Project, MS Access, and MS Word to replace AccessBASIC and WordBASIC respectively. Soon after it was launched, VBA became an instant success among developers, who used the coding language to create corporate solutions using Excel. Microsoft first launched VBA in 1993 with MS Excel 5.0. Net platform version while VBA is still in use. While VB is represented as a stand-alone application and can make stand-alone executables, VBA deals mainly with programming in MS Office applications. Although the names sound similar and both languages share the same origin, VBA is different from VB (Visual Basic). Perhaps, you don’t know or have forgotten, VBA stands for Visual Basic for Applications.
VISUAL BASIC FOR APPLICATIONS 7.1 UPDATE
Even if Microsoft eventually stopped support and update for VBA, which it has not done yet, there would still be a need for ongoing support for systems running on VBA just as there is still on-going support for large COBOL systems.įinally, while students who embark on learning computer languages nowadays may disregard learning VBA due to its “supposed” future irrelevance to their IT careers, VBA, as well as its knowledge, will remain extensively useful for many years to come. Just like FORTRAN and COBOL, VBA is here to stay and it’ll stay for a very long time – VBA is part of the MS Office 2019 Suite despite the rumor of VBA’s near-extinction. The use of VBA has gone far and wide in many industries than the application can suddenly become obsolete. More so, VBA is used to interconnect these applications, for instance, connecting coordinates and tables from Excel to AutoCAD. In a simple term, NO, VBA is not outdated and is not getting outdated any time soon.Ĭurrently, the use of VBA has spread across several applications, which include AutoCAD, CorelDraw, WordPerfect, LibreOffice, etc.
This post is specially written to provide an answer to the question, “ Is VBA Outdated?” read on to get a better understanding of VBA, it’s current stand, and its likelihood to become outdated.Ĭlick this affiliate link to register for Microsoft Excel VBA Training. This seemingly eliminated the need for VBA and backed the prove that VBA may soon be ditched. This was ongoing when it became possible and easy to use Python in Excel – thanks to the xlwings library.
VISUAL BASIC FOR APPLICATIONS 7.1 UPGRADE
But when Microsoft suddenly upgrade VBA to VBA 7 in Microsoft Office Suites in 2010, this generated lots of arguments about whether VBA is going into extinction or not.Ĭlick this affiliate link to start learning Microsoft Excel 2019.
The prediction that VBA is becoming obsolete was further strengthened when Microsoft stopped support and update for VBA in 2007. This is unconnected to the fact that Python, a newer programming language, can do virtually all that VBA can do and even execute them better and more efficiently than VBA. However, there have been lots of discussions recently about Excel VBA being outdated.
0 kommentar(er)
