Content deleted Content added
m Updated support details |
Adfontes18 (talk | contribs) Revision to include history/origins of BASIC as a core technology |
||
Line 26:
VBA is built into most [[Microsoft Office]] applications, including Office for Mac OS X (except version 2008), and other Microsoft applications, including [[Microsoft MapPoint]] and [[Microsoft Visio]]. VBA is also implemented, at least partially, in applications published by companies other than Microsoft, including [[ArcGIS]], [[AutoCAD]], [[Collabora Online]], [[CorelDraw]], [[WPS Office|Kingsoft Office]], [[LibreOffice]],<ref>{{cite web | title=Support for VBA Macros | publisher=The Document Foundation - LibreOffice| url=https://help.libreoffice.org/latest/lo/text/sbasic/shared/vbasupport.html |access-date=3 January 2023}}</ref> [[SolidWorks]],<ref>{{Cite web|url=http://help.solidworks.com/2016/English/SolidWorks/sldworks/c_vba.htm|title=2016 SolidWorks Help – VBA|website=help.solidworks.com|access-date=2016-07-25}}</ref> [[WordPerfect]], and UNICOM [[System Architect]] (which supports VBA 7.1).
==Origins==
When personal computers were initially released in the 1970s and 1980s, they typically included a version of BASIC so that customers could write their own programs. Microsoft's first products were BASIC compilers and interpreters, and the company distributed versions of BASIC with MS-DOS (versions 1.0 through 6.0) and follow-on products that offered more features and capabilities (QuickBASIC and BASIC Professional Development System).
In 1989, Bill Gates sketched out Microsoft's plans to use BASIC as a universal language to embellish or alter the performance of a range of software applications on personal computers.<ref>{{cite book |last1=Gates |first1=Bill |last2=Halvorson |first2=Michael |last3=Rygmyr |first3=David |title=Learn BASIC Now |date=1989 |publisher=Microsoft Press |___location=Redmond, WA |pages=ix-x}}</ref> He also revealed that the installed base of active BASIC developers was four million users, and that the language was used three times more frequently than any other language on personal computers.
When Visual Basic was released in 1991, it seemed logical to use Visual Basic as the universal programming language for applications. Until that time, each Microsoft application had its own macro language, and they were largely incompatible. Several applications, such as Microsoft Access and Microsoft Word, had macro languages derived from structured BASIC.
The first Microsoft application to debut VBA was Microsoft Excel 5.0 in 1993.
==Design==
| |||