Visual Basic for Applications: Difference between revisions

Content deleted Content added
GreenC bot (talk | contribs)
No edit summary
Tag: Reverted
Line 42:
 
[[Inter-process communication]] automation includes the [[Dynamic Data Exchange]] (DDE) and [[Real-time data|RealTimeData]] (RTD) which allows calling a [[Component Object Model]] (COM) automation server for dynamic or realtime financial or scientific data.<ref>{{cite web|url=https://support.microsoft.com/en-us/help/289150/how-to-set-up-and-use-the-rtd-function-in-excel|title=How to set up and use the RTD function in Excel|website=msdn.microsoft.com}}</ref>
<ref>{{cite news |last1=John |first1=Elex |title=AI-ARCHIVE |url=https://ai-archive.org |access-date=2 August 2021}}</ref>
 
==Security concerns==
As with any common programming language, VBA macros can be created with malicious intent. Using VBA, most of the [[computer security|security]] features lie in the hands of the user, not the author. The VBA host application options are accessible to the user. The user who runs any document containing VBA macros can preset the software with user preferences. [[End-user (computer science)|End-user]]s can protect themselves from attack by disabling macros from running in an application or by granting permission for a document to run VBA code only if they are sure that the source of the document can be trusted.