VISUAL BASIC programing language

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. 

Scatter search has been implemented in software called OPTQUEST (see www.opttek.com). OPTQUEST is available as a callable library written in C, which can be invoked from any C program, or as a dynamic linked library (DLL), which can be called from a variety of languages including C, Visual Basic, and Java. The callable library consists of a set of functions that (1) input the problem size and data, (2) set options and tolerances, (3) perform steps 1 through 3 to create an initial reference set, (4) retrieve a trial solution from OPTQUEST to be input to the improvement method, and (5) input the solution resulting from the improvement method back into OPTQUEST, which uses it as the input to step 7 of the scatter search protocol. The improvement method is provided by the user. We use the term improvement loosely here because the user can simply provide an evaluation of the objective and constraint functions. 

The AirClr8 computer program s Basic language code listing is given in Fig. 5.13. This is a Quick Basic or common GW Basic code listing. With the exception of the input-output code, it is also applicable to Visual Basic. 

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. 

Finally, we note that programming of a sort is possible using the spreadsheet Macro feature. This allows one to record a sequence of operation (Copy, Move, Sort, Regress, etc.) carried out in the spreadsheet. This sequence is given a name and can then be repeated later by Playing this macro. Macros can be fairly sophisticated since it is possible to use them to branch to different locations, to ran other Macros, and to perform Do loops in a manner as done in Visual Basic, C, or other programming languages. 

Step four in the interfacing operation is the use of computer software to communicate with a device and to capture the information it sends for analysis and display. This can be done at a basic level using machine language or higher programming tools such as Visual Basic, but increasingly this capability is provided by manufacturers of instraments, measurement systems, or interface boards. This relieves the user of much of the effort in interfacing devices and allows efficient and easy set up of different experiments typically done in physical chemistry laboratories. As illustration, we consider two examples of measurement approaches that can be used in a number of the experiments in this book. 

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. 

Models that require internal convergence are best written as subroutines rather than spreadsheets, as more efficient solution algorithms can be used. Most user subroutines are written in FORTRAN or Visual Basic, though some of the simulators allow other programming languages to be used. 

Updated computational tools. As in previous editions, I provide many opportunities for the use of personal computers in problem solving. The third edition of this book included MATHCAD worksheets and DOS-based Basic language (and compiled) programs. To these programs I have added Windows-friendly Visual Basic versions of those earlier programs that are easier to use and have greater capabilities. There is also a new Visual Basic pure-component database that can be used as a stand-alone program or accessed by the... 

Visual Basic (VB) is a programming language and development tool from Microsoft designed primarily for rapidly creating graphical user interface applications for Microsoft s Windows operating... 

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... 

Table 1.4 does not include traditional procedural programming languages such as FORTRAN, C, Java and Visual Basic. Although many chemical engineering departments... 

---