Visual Basic for Applications: Difference between revisions

Content deleted Content added
m Reverted edits by Filedelinkerbot (talk) to last version by 2406:B400:60:A17:39AB:567B:C60:18
Added Collabora Online as an app that supports VBA partially
Line 25:
As its name suggests, VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library. However, VBA code normally can only run within a host application, rather than as a [[standalone program]]. VBA can, however, control one application from another using [[OLE Automation]]. For example, VBA can automatically create a [[Microsoft Word]] report from [[Microsoft Excel]] data that Excel collects automatically from polled sensors. VBA can use, but not create, [[Component Object Model|ActiveX/COM]] DLLs, and later versions add support for class modules.
 
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> [https://www.microfocus.com/products/reflection/desktop/ Reflection],<ref>{{Cite web|url=http://docs.attachmate.com/reflection/16-1/vba-prog-guide|title=Reflection Desktop VBA Guide|website=docs.attachmate.com|access-date=2017-07-01}}</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).
 
==Design==