Hysys Excel Automation

Hi there, This post is requested by Mayembe. He asked me to post a VBA code in Excel to access Hysys splitter. Here is the VBA example ================================================= ' VBA code starts here Option Explicit Public hyApp...

Now, we're trying to access pipesegment on Aspen Hysys 7.3 through VBA. This post is an answer of previous post comment. Here is the example Create a table as shown figure Then add following VBA code Option Explicit Public hyApp...

It has been so long time not to update this blog. And now I'm posting how to access stream component fraction, component molar flowrate and mass flowrate. Here is the VBA example Option Explicit Public hyApp As HYSYS.Application Public...

I forgot to mention about this one. Hysys simulation won't run if there is no Hysys Library on Excel. Hysys library can be found and activated through Microsoft Visual Basic - Tools - References. Find Hysys Type Library, activate by check...

Linking Hysys Simulation to access HYSYS UNIT OPERATION VALVE using VBA macro. Here is the source code: ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Option Explicit Public hyApp As HYSYS.Application Public simCase...

How to link Hysys Simulation to Excel? Open Example1.HSC. This file is generated in Aspen Hysys V7.1, may not work in previous version of Hysys, such as Hysys 2006 or Hysys 3.2. If you have older version of Hysys, make your own simulation...