Introduction to visual basic for applications (vba)

Introduction to Visual BASIC for Applications / PDF

Excel Files

Files used in this lecture.
 vbIntroClean.xlsm


Programming Languages

Programming languages are used to create applications. For example, the Microsoft Excel application was written in the C programming language.

Learning Objectives:
1. Understand the di erence between a compiled programming language and a scripting language.
2. Understand the role of Excel/VBA and MATLAB
3. Understand key tradeo s


The following are some popular high-level, languages that have been used to create applications.

COBOL (common business-oriented language) An old language from the 1950s which was designed for accounting and transaction processing.

 FORTRAN (formula translation) An excellent language for numerically intensive work.

 C, C++ Good for numerical applications and scienti c computing. It is also used for writing many desktop
applications. C++ is the object oriented version of C.

 Java An extremely popular language for developing Internet business applications.

C# A language from Microsoft designed to facilitate the development of Internet business applications.

Compilers

A few key points.

I The executable code created by the compiler is platform dependent.

I The executable code generated by the compiler cannot be modi ed or edited { you must go back to the source code.

I The executable code is binary as opposed to source code which is text.

I When purchasing software, negotiate to get the source code if possible.........

Introduction to Visual BASIC for Applications / PDF