Visual Basic For Applications - Language

Language

Code written in VBA is compiled to a proprietary intermediate language called P-code (packed code), which the hosting applications (Access, Excel, Word, Outlook, and PowerPoint) store as a separate stream in COM Structured Storage files (e.g., .doc or .xls) independent of the document streams. The intermediate code is then executed by a virtual machine (hosted by the hosting application). Despite its resemblance to many old BASIC dialects (particularly Microsoft BASIC, from which it is indirectly derived), VBA is incompatible with any of them except Visual Basic, where source-code of VBA modules and classes can be directly imported, and which shares the same library and virtual machine. Compatibility ends with Visual Basic version 6; VBA is incompatible with Visual Basic .NET (VB.NET). VBA is proprietary to Microsoft and, apart from the COM interface, is not an open standard.

Read more about this topic:  Visual Basic For Applications

Famous quotes containing the word language:

    There is no such thing as an ugly language. Today I hear every language as if it were the only one, and when I hear of one that is dying, it overwhelms me as though it were the death of the earth.
    Elias Canetti (b. 1905)

    “What may this mean? Language of Man pronounced
    By tongue of brute, and human sense expressed!
    The first at least of these I thought denied
    To beasts, whom God on their creation-day
    Created mute to all articulate sound;
    The latter I demur, for in their looks
    Much reason, and in their actions, oft appears.
    John Milton (1608–1674)

    Man, even man debased by the neocapitalism and pseudosocialism of our time, is a marvelous being because he sometimes speaks. Language is the mark, the sign, not of his fall but of his original innocence. Through the Word we may regain the lost kingdom and recover powers we possessed in the far-distant past.
    Octavio Paz (b. 1914)