26 replies to this topic

[alphadian]

Hy everyone.

i want to Link my hysys simulation to excel, so i can work in excel too. can you help me, please?? what should i do?
thanks...

[Technical Bard]

The Aspen Simulation Workbook, which you need to license separately, is one way. Alternatively, you can write VBA code underneath Excel to connect to the HYSYS COM object and interact with it that way. The HYSYS type library (hysys.tlb) is relatively well documented and Aspen has some training material on how to do this.

[Alexsandres]

alphadian,

As Bard said, i use VBA code to link excel and hysys. I posted examples how to link excel and hysys several months ago, hope this link helps.
http://hysyssimulations.blogspot.com

Alex

[sacarove]

Hi Alex,

Thank you for sharing that. I want to export the molar fraction components to excel. Because it is an array I am trying to use "For" loop but I am getting error when I run it.
Can you please assist on that from your VBA code?

Thanks

Sacarove

[Bobby Strain]

You only need to set up array when importing from Excel into HYSYS. Get the workdump project from the support site and you will find all the code you need. There is also a project called stream reporter. Lots of code.

Bobby

[Marry Sheikh]

Hi Alphadian,
There is no such a need for VBA code or its programming for creating a link between excel and hysys. Just download a file named as "Workbook Dump" and use it while remaining the hysys file open. I think it will be quite easy for you.Thanks

[Joyce J. Ruiz]

What is VBA Code?

[Dacs]

What is VBA Code?

Something that you rely heavily on when linking Hysys with Excel, or making Excel much more functional for that matter.

VBA stands for Visual Basic for Applications, basically an implementation of Visual Basic (which is a programming language) for your Windows application.

[Bobby Strain]

And it is available in Microsoft EXCEL. And, you can use VB, too, which is a free Microsoft product.

Bobby

[Padmakar Katre]

Hi,
The link might be useful for few of you.

http://www.cheresour...xcel-converter/

[Alexsandres]

savarove, you may use this code to obtain molar composition

===================================================

Dim ambildata As ProcessStream, item as integer

 

Set ambildata = simCase.Flowsheet.MaterialStreams.ITEM(“stream1”)

 

For ITEM = 1 To 24                ' i have 24 components on "stream1"

 

Cells(2,  ITEM).value
= ambildata.ComponentMolarFractionValue(ITEM - 1)

 

Next ITEM

===================================================

 

 

hope this help, I'm sorry for late respond.

 

Alex

 

 

[Dacs]

I think you forgot to mention these on your post:

1. You need to use VBA to execute that

2. You did not include the initialization of simCase, which should be either a class that belongs to Hysys.SimulationCase or Hysys.Application

 

[Sathya R]

Hysys Stream Reporter can be used generate the data in Excel. This utility can be found in the internet or will be given as part hysys basic training. If you have token system, you can use aspen simulation work book to link the data to excel.

[hetianbiao]

I think VBA is necessary for hysys link to excel

[RockDock]

Wow. That seems a lot more difficult than it is in ProMax. In ProMax, you just right click on on any value and select export to excel.

 

Or you can use the scenario tool demonstrated here:

 

[Dacs]

ProMax is run with Visio, so I suppose exporting to Excel would be easier than with Hysys

[Process Eng]

Hi everybody ;

Please try the following steps to link Hysys to Excel:

• open your simulation case
• open a new excel sheet
• copy the value to be linked to excel (for example the mass density) you can use (Ctrl+C)
• go to the new excel sheet, click on the right button of the mouse and select special paste.
• the table of special paste will appear; select coller avec liaison (or paste with link) and select text, then OK.

Now if you change for example the related temperature on your simulation case you can see that the value of mass density will change in the excel sheet. By this method you can link all your required data to the excel.

I hope that this can help you.

regards.

[sacarove]

Dear all,

i am back with the exporting composition to hysys.

 

I am getting an error saying object does not support this propriety or method.

 

Attached is the code.

 

Option Explicit

Public hyApp As HYSYS.Application

Public simCase As SimulationCase

Public pStream As ProcessStream

Public Sub StartHYSYS()

Dim filename As String

Dim ITEM As Integer

Dim STREAM1 As Streams, STREAM2 As Streams

Dim Compositions As Variant

'Loading customation throgh excel to access stream components

'Loading hysys simulation file

 ' LOADING HYSYS SIMULATION FILE

    Set hyApp = CreateObject("HYSYS.Application")

    hyApp.Visible = True

    Set simCase = hyApp.ActiveDocument

    If simCase Is Nothing Then

        filename = Worksheets("Sheet1").Range("c4")

        

        If filename <> "False" And simCase Is Nothing Then

            Set simCase = GetObject(filename, "HYSYS.SimulationCase")

            simCase.Visible = True

        End If

    End If

        

  'Read Data from Excel to stream

  Set pStream = simCase.Flowsheet.MaterialStream.ITEM("STREAM1")

  Compositions = pStream.ComponentMolarFractionValue

  For ITEM = 0 To 11 ' Collect composition data as variant

        Compositions(ITEM) = Worksheets("HYSYS").Range("D" & ITEM + 7).Value

        'Cells(6, ITEM).Value = pStream.ComponentMolarFractionValue(ITEM - 1)

        

  Next ITEM

  

  'Apply composition data

  pStream.ComponentMolarFraction.Values = Compositions

  

  'Write composition data from HYSYS to Excel from stream3

  Set pStream = simCase.Flowsheet.MaterialStreams.ITEM("Stream3")

  For ITEM = 0 To 11 'number of components are 12

  

  ' component molar fraction

Worksheets("HYSYS").Range("E" & ITEM + 7).Value = pStream.ComponentMolarFraction(ITEM)

  ' component mass flowrate

Worksheets("HYSYS").Range("F" & ITEM + 7).Value = pStream.ComponentMassFlow(ITEM)

   ' component molar fraction

Worksheets("HYSYS").Range("G" & ITEM + 7).Value = pStream.ComponentMolarFlow(ITEM)

Next ITEM

 

 'FINISH

        

End Sub

 

 

Thanks

Sacarove

[Bobby Strain]

Before you can import stream compositions, you must set the array in HYSYS by setting each component flow to 0. Then all will work well. There may be an example on the AspenTech site.

 

Bobby

[sacarove]

Thanks Bod,

I was making some mistakes on the code.

It is now running.

Sacarove

[sacarove]

Dear All,

I am having an Out of range error  on the code below:

 

    For ITEM = 1 To 4

    p_length(ITEM - 1) = Cells(6, ITEM + 2)

        p_elev(ITEM - 1) = Cells(7, ITEM + 2)

        p_odiam(ITEM - 1) = Cells(8, ITEM + 2)

        p_idiam(ITEM - 1) = Cells(9, ITEM + 2)

        p_rough(ITEM - 1) = Cells(10, ITEM + 2)

        p_cond(ITEM - 1) = Cells(11, ITEM + 2)

 

Can anybody help on this error?

 

Thanks

 

Sacarove

[sacarove]

Dear all,

i want to fetch  a value from the spreadsheet I have in hysys.

How the vba code would look like?

 

Thanks

Sacarove

[siphe2013]

Thank you thank you thank you! I was getting a just a little bit annoyed because I couldn't get the values from my case file to update on my aspen workbook in excel, this has helped me a lot!

 

Hi everybody ;

Please try the following steps to link Hysys to Excel:

• open your simulation case
• open a new excel sheet
• copy the value to be linked to excel (for example the mass density) you can use (Ctrl+C)
• go to the new excel sheet, click on the right button of the mouse and select special paste.
• the table of special paste will appear; select coller avec liaison (or paste with link) and select text, then OK.

Now if you change for example the related temperature on your simulation case you can see that the value of mass density will change in the excel sheet. By this method you can link all your required data to the excel.

I hope that this can help you.

regards.

 

[masebinu]

hi all, please does any one have a code that i can use to generate a user defined module for a membrane in Aspen plus. i am stocked and can make much progress with my simulation.

[aliisd]

Hi everybody ;

Please try the following steps to link Hysys to Excel:

• open your simulation case
• open a new excel sheet
• copy the value to be linked to excel (for example the mass density) you can use (Ctrl+C)
• go to the new excel sheet, click on the right button of the mouse and select special paste.
• the table of special paste will appear; select coller avec liaison (or paste with link) and select text, then OK.

Now if you change for example the related temperature on your simulation case you can see that the value of mass density will change in the excel sheet. By this method you can link all your required data to the excel.

I hope that this can help you.

regards.

Hello everybody,

 

Do you know how to export data from excel to HYSYS, as well? 

 

Thank you very much,

Regards