7 replies to this topic

[Bal]

Hello,

 

How can I link a hysys spread sheet in one hysys simulation to another spreadsheet in a different hsysy simulation?

 

 

Thanks!

[Bal]

Any idea??

[bhautesh.mistry@gmail.com]

Hi!

 

I think you can connect your both HYSYS file with Excel through VBA. Thereafter you can link hysys spreadsheet of first file to spreadsheet of second file by writing correct codes in VBA.

 

Regards,

Bhautesh

[Lucian Gomoescu]

Hello everyone,

There are more possibilities:

 

1. The one suggested by Bhautesh Mistry.

 

2. Use Macro Language Editor from Tools within HYSYS. Write with it the VBA subroutine. This option has the advantage that you don't need Excel.

 

See the attached example ( change case 1 and 2 extension to hsc and open them, then open Macro1.wwb file in HYSYS's Macro Editor and run it; i had to change the extension of these files because i couldn't upload the files with extension hsc, respectively wwb).

 

Options (1) and (2) have the same sad disadvantage that you have to run the macro manually every time the spreadsheets have to be updated. In other words, they don't assure a "live link", or at least i had not discovered yet the proper events to be used with this purpose.

 

3. Go to Tools > Case Collaboration and publish the spreadsheet blocks. Unfortunately you have to solve the Data Server, thing which i've never done so i can't give advice for now.

 

4. There may be a trick with the events assured by user variable code, among which is the variablechanged(). It is worthy to try.

 

Options 3 and 4 assure "live links".

 

Good luck,

Lucian

 

Attached Files

•  CASE1.txt   32.51KB   48 downloads
•  CASE2.txt   30.87KB   30 downloads
•  Macro1.txt   1.35KB   47 downloads

[abubakarce19]

you can also copy one simulation in other with its spread sheet. connect both simulation using recycle loop. In hysys recycle loop do not work as recycle process loop in different process systems, but divides the solution of simulation in two parts. so when one get solve other one will get results.

 

thanks 

ABS

[Bal]

Thanks a lot every1

[bhautesh.mistry@gmail.com]

Hi everyone!

 

In addition to this post, can anyone suggest me to link Matlab and HYSYS file. i want to solve an optimization problem.

 

Regards,

Bhautesh

[suria07100]

@Bhautesh Mistry

Maybe you can begin by writing code with VBA, link Excel and Hysys, then link Excel and MATLAB via COM/API (mostly via VBA and matlab).

 

Link below shows how to link MATLAB and Aspen plus (not Hysys, maybe useful)