You can in principle set stream values and unit operation parameters from VBA and call the Calculate method of the flowsheet, and pull the results out. In other words, it is not so difficult to do the parametric study directly from VBA in Excel.
Setting stream values can be done via the CAPE-OPEN material object interface. Setting unit operation parameters can be done via the CAPE-OPEN unit operation and parameter interfaces. Solving the flowsheet:
Please see the existing VBA code to see how to get to these interfaces.Statistics: Posted by jasper — 20 May 2017, 06:50
]]>