by jasper » 20 May 2017, 06:50
When running in Excel I do not have the option to present multiple windows. All items that open a new window (calculator, plots, parametric study) are therefore disabled. Without the ability to switch back and forth to the result window, it is not straight forward to represent the results.
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.