--------------------------------------------------------------------- E-PROPATH : Libraries for MS-EXCEL by RYO, Akasaka (akasaka@mech.kyushu-u.ac.jp) April 6, 1999 --------------------------------------------------------------------- E-PROPATH is a collection of Library FILEs and Import FILEs for MS-Excel. Using this PROPATH facility, user may use other PROPATH SUBPROGRAMs while working in MS-Excel. However, reference to PROPATH SUBPROGRAM is limited to PROPATH FUNCTION SUBPROGRAMs in P-PROPATH and A-PROPATH at this moment. System of Unit =================== In E-PROPATH, the unit of pressure is limited to [bar] and that of temperature is limited to [C]. Functions Available ======================== All FUNCTIONS in P-PROPATH and A-PROPATH, except CHARACTER argumented FUNCTION, are available. Operation to Manage Erroneous FUNCTION REFFRENCE ===================================================== The same is done as in SUBPROGRAMs in P-PROPATH and A-PROPATH, though no error messge appears. How to Use E-PROPATH ======================== The procedure to use water Library FILE from MS-Excel is illustrated here. The files required are JH2O.DLL and JH2O.BAS. The procedure to use other Library FILE is similar. 1. Copy JH2O.DLL and H2O.BAS to the hard disk drive on your computer. The destination directory of JH2O.BAS is a free choice. However, the destination directory of JH2O.DLL must be one of following directories; - Windows directory (example: C:\WINDOWS) - Windows system directory (example: C:\WINDOWS\SYSTEM) - directories specified by enviromental variable "PATH" We recommend copying Library FILEs to PATH directories, because a conflict of file name may occur in case of copying to Windows directory or Windows system directory. 2. Execute Microsoft Excel. 3. Select [Tools] - [Macro] - [Visual Basic Editor], then VISUAL BASIC EDITOR starts. 4. On VISUAL BASIC EDITOR, Select [File] - [Import File...]. 5. Select H2O.BAS copied to your hard disk drive and press [Open] button. 6. If the "JH2O" module appears in Project Explorer on VISUAL BASIC EDITOR, the import of JH2O.BAS is successful. 7. Select [File] - [Close and Return to Microsoft Excel]. 8. If the import of H2O.BAS has been successfully completed, user can call any FUNCTION included in JH2O.DLL. For example, if user wishes to calculate vapor pressure at 100 C, input "=PST(100)" to any cell and press the return key. The result "1.013253" will be shownin the cell immediately. If the message "#VALUE!" is shown, make sure that JH2O.DLL exists in the prescribed directories. User's manual may tell you more imformation about how to use E-PROPATH. Please see it.