Forum Discussion
Solved
Exporting mathematical model in Excel into a script
Dear Community: I have been using Excel for modelling Chemical Process Engineering since a while ago. I find it convenient, as it is visual, easily portable and easily accessible. I was wond...
- Formula from Excel to text file is possible to be exported/copied using VBA macro. VBA works like other programming languages,, has enough capacity also. You need to work in either way ,, read value from sheet or input through User Form,,, ultimately it needs values to be calculated.
First let me tell you that SOLVER finds an optimal value either maximum or minimum, for formula called the objective cell,, subject to constraints, on the values of other formula cells on a worksheet.
In your case solver hardly works,,, Coz for the Vapor & Mass are independent values (what I found in the Example WB).
If you can handle VBA then I may suggest you method to use Excel formula with VBA code,,, another possibility is using the recently launched LAMBDA,, provides a way to create a custom function, helps to use with Math/Physics base equation in Excel.