VBA is not a low level language.
It was an analogy that management could understand.
I still marvel at management.
You’re correct. VBA is considered high-level programming.
I’m using it every day in my post-retirement job, and I don’t miss Assembler or COBOL at all.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
AI Overview:
VBA (Visual Basic for Applications) is considered a high-level programming language, designed to be relatively easy to learn and use for automating tasks within Microsoft Office applications and other compatible software.
Here’s a more detailed explanation:
High-Level Nature:
VBA is a high-level language, meaning it’s designed to be closer to human language than machine code, making it easier to understand and write code.
Based on Visual Basic:
VBA is based on the Visual Basic language, which is known for its relatively simple syntax and ease of use.
Application-Specific:
VBA is designed to work within specific applications, such as Microsoft Excel, Word, PowerPoint, etc., rather than being a standalone programming language.
Macro Programming:
VBA is primarily used for creating macros, which are sequences of commands that can be used to automate repetitive tasks.
Automation and Customization:
VBA allows users to automate tasks, create custom functions, and extend the functionality of Microsoft Office applications.
Not a Standalone Language:
VBA code typically runs within the context of the host application and cannot be compiled into a standalone executable.
Interpreted Language:
VBA is an interpreted language, meaning the code is executed line by line rather than being compiled into machine code first.
Object-Oriented:
VBA supports object-oriented programming concepts, allowing for the creation of reusable code and the manipulation of objects within the host application.
Learning Curve:
While VBA is considered relatively easy to learn compared to other languages, it still requires some effort to master its syntax and features.