Basic for Applications Programming

Excel comes with its own programming language, VBA (or Visual Basic for Applications). This can be used to produce macros , which are programs diat can be ran in Excel. 

Beginning with Excel 5.0, Microsoft introduced a new macro language for Excel — Microsoft Visual Basic for Applications, or VBA. The VBA language and programming environment was changed considerably in Excel 97/98, and changed somewhat more in Excel 2000/2001. 

Excel has the capability of using routines called Macros that can be called inside the spreadsheet. These routines can be programs written in a version of the BASIC programming language called Visual Basic for Applications. Macros can be obtained from other sources, such as internet websites, and placed in any spreadsheet. 

The CodeGen and Decode programs are applications written for Microsoft Access 97, using the programming language Visual Basic for Applications, Proper installation is required because the application uses three different MS Access databases and several Oracle database tables used by MDL (Molecular Design Ltd.) ISIS/Host and ISIS Base. To access... 

The program is based on a Microsoft Excel 97 spreadsheet which includes some Visual Basic for Applications macros. Macro SP is used for the general control, which when needed calls the other 14 subroutines. 

The programs are written in Visual Basic for Applications (VBA) for execution in Microsoft Excel . They can be downloaded from the companion website (Files DISPERSION 1, DISPERSION2, FUMIGATION 1, FUMIGATION2). 

The Lewis method for binary distillation is easy to program on a spreadsheet using Visual Basic for Applications (VBA). If you are not familiar with VBA, read Appendix 4.B. Part 1. If you are familiar witii VBA, you can skip Part 1 and proceed to Part 2. 

Excel has built-in capability to generate customized functions using Visual Basic for Applications (VBA). This is a powerful tool that can save time without becoming an expert in programming as it opens the possibilities to run loops and conditionals on the background. This capability also allows the user to build relatively large equations that are used in several areas of the worksheet (e.g., polynomials for the estimation of specific heat of components) and allows the user to read the calculations... 

This example gives a very first look at Visual Basic for Applications (VBA), which is the programming language associated with Excel (as well as all other Microsoft Office applications). The example also introduces the use of Keystroke Macros,... 

Most database users do not know how the data are organized in a database system (DBS) they depend solely on the application programs. This is sufficient for most database searches where users can receive large amounts of results quickly and easily, e.g., on literature or other information. Nevertheless, a basic knowledge on where and how to find deeper or more detailed information is quite useful. Due to their complex nature, comprehensive searches (e.g., for processes or patents) are not recommended for beginners. However, most local (in-house), online, and CD-ROM databases provide extensive tutorials and help functions that are specific to the database, and that give a substantial introduction into database searching. 

---