Visual Basic for Application

The Library Studio Developer s Kit further extends Library Studio by embedding Microsoft s Visual Basic for Applications (VBA) into the Library Studio application. With VBA, the user can import data from statistical packages, such as DOE, or export data for further manipulation, such as a bubble point calculation. Additionally, modifications to the Library Studio user interface are possible via custom add-ins, such as commands to produce automated designs or validate a design intended for a particular instrument. 

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. 

The Group Theory Calculator [the GT Calculator] is the set of interactive EXCEL spreadsheet files, one for each of the main molecular point groups, on the CDROM supplied with this manual. The group theoretical calculations, which can be performed with the calculator, are rendered possible because of the enhancement of the basic spreadsheet operations and displays using Visual Basic for Applications code and the complex-arithmetic routines available in the Analysis Tool Pack EXCEL Add-ins . Since the Analysis Tool Pack is not one of the standard components loaded in a typical installation of the EXCEL software package, it is necessary, before attempting to use the GT Calculator, to ensure that your version of the EXCEL programme includes this extra component. With any spreadsheet open, check the Add-ins list in the TOOLS menu on the main EXCEL toolbar and, if necessary, install this component in the usual way. 

This book describes the approach to applied group theory that we have developed in the past twenty-five years and illustrates how this approach, known as the Spherical Shell method, can be applied to solve a variety of problems that benefit from a group theory analysis. To complement the theory, the book is supplied with a CDROM, on which interactive files, based on EXCEL spreadsheet technology controlled by Visual Basic for Applications [VBA] code, can be used to perform straightforwardly group-theory analyses for direct application to the simplification of physical problems in Chemistry, Physics and even Engineering Science. 

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. 

Reed Jacobson, Microsoft Excel 2000 Visual Basic for Applications Fundamentals, Microsoft Press, Redmond, WA, 1999. 

FIGURE 18.3 The Object Browser of the Excel Visual Basic for Applications Integrated Development Environment is set up to explore the Mass Spectrometer Method Server Library (MSMethodSvr.dll) provided with Sciex Analyst version 1.3. 

Visual Basic for Applications (VBA) is an implementation of Microsoft s Visual Basic built into all Microsoft Office applications (including Apple Mac OS versions) and some other Microsoft applications such as Microsoft Visio. 

Note that the version of VBA included with recent versions of Excel is a dialect of Visual BASIC. It is, at the same time, a subset and an extension, because it is specialized for use with a spreadsheet. Therefore, ifyouwantto learn more about VBA, consult books on VBA for Excel rather than those on Visual BASIC, because quite a few of the commands ofVisual BASIC do not exist in VBA, and vice versa. Of the many books available, useful early introductions are E. Boonin, UsingExcel Visual Basic for Applications, thefast and easy way to learn, Que (1996), and R. Jacobson, Microsoft Excel / Visual Basic, Step by Step, Microsoft Press (1995). As a general reference book use the Microsoft Excel / Visual Basic Programmer s Guide, Microsoft Press (1995). An extensive recent manual is J. Green, Excel 2000 VBA, Wrox Press (1999). Section 10.12 briefly summarizes the main syntactic features ofVBA. 

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. 

If you know how to use Visual Basic for Applications, you can write a Macro and use it in an Excel spreadsheet to carry out the calculation of this exercise. 

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

---