© 2021 Jasper van Baten, AmsterCHEM

Macros

Your workbook is saved as .xlsx file, which implies you cannot have VBA macros directly in your workbook. If you need to use external macros, you must supply your own Add-In, e.g. an .xlam file.

The following approach is advised instead:

If you transfer the Excel Unit Operation that uses Add-ins to a different system, make sure that the Add-In is also transferred to the different system. Again, preferred is to put it in the XLStart folder (in the Office installation folder, or in the Excel sub-folder of the user's Application data folder). You may or may not get a warning from Excel that the Add-Ins cannot be found, the first time you open the unit operation. Ignore the warnings; the Excel Unit Operation will resolve the references. If you are asked to update links, answer No. If you are asked to enable automatic links resolution, answer Disable:

Disable link resolution

INDEX
add-In
aggregation state
available properties
capeCompoundConstant
capePropertyUnit
capeFlash
capeFlashedFeed
capeOverallFeedProperty
capeOverallProperty
capePDependentProperty
capeSinglePhaseProperty
capeCompoundNames
compound names
unit of measure
capeStateOfAggregation
capeTDependentProperty
capeTwoPhaseProperty
capeUnitOperationName
compound constants
control sheet
defined phases
Disclaimer
equilibrium calculations
examples
Excel solver
Export Model
feeds
flash calculations
getting started
Import Model
input parameters
Loading and storing models
macros
output parameters
overall properties
parameters
ports
pressure dependent properties
products
property calculations
quick reference
reports
requirements
run-time error
security
single phase properties
solver
state of aggregation
streams
temperature dependent properties
thermodynamic equilibrium calculations
thermodynamic property calculations
two-phase properties
unit operation name
Update links
validation
VBA
welcome
CONTENT
 Introduction
 Ports and streams
 Parameters
 Function reference
 The control sheet
 Using the Excel solver
 Using Macros
 Loading and storing models
 Persistence in AspenPlus
 Examples
 Disclaimer