A Perspective: The Use of the Spreadsheet for Chemical Engineering Computations
Edward M. Rosen, L. R. Partin · Industrial & Engineering Chemistry Research · 2000
The modern spreadsheet program as exemplified by Microsoft's Excel (version 5 and higher) 1 has developed into a suitable platform for carrying out a large variety of chemical engineering computations. The availability of its macro language, Visual Basic for Applications (VBA), played a key role in this capability. VBA provides a programming environment for developing new software applications. It also allows Excel to link with programs written in other languages such as FORTRAN. Therefore, the wealth of existing FORTRAN programs and numerical methods can be converted for application in Excel.