|
How To Link Hysys To Excel
#1
Posted 12 April 2012 - 04:29 AM
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...
#2
Posted 12 April 2012 - 09:52 PM
#3
Posted 15 May 2012 - 05:09 AM
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
#4
Posted 06 November 2012 - 08:25 AM
#5
Posted 06 November 2012 - 02:03 PM
Bobby
#6
Posted 08 November 2012 - 05:13 AM
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
#7
Posted 15 November 2012 - 02:38 PM
#8
Posted 15 November 2012 - 07:46 PM
Something that you rely heavily on when linking Hysys with Excel, or making Excel much more functional for that matter.What is VBA Code?
VBA stands for Visual Basic for Applications, basically an implementation of Visual Basic (which is a programming language) for your Windows application.
#9
Posted 15 November 2012 - 10:02 PM
Bobby
#10
Posted 12 December 2012 - 02:19 AM
#11
Posted 28 February 2013 - 01:22 AM
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
#12
Posted 04 March 2013 - 12:44 AM
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
#13
Posted 04 March 2013 - 04:17 AM
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.
#14
Posted 11 March 2013 - 11:30 PM
I think VBA is necessary for hysys link to excel
#15
Posted 12 March 2013 - 09:13 AM
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:
#16
Posted 12 March 2013 - 06:54 PM
ProMax is run with Visio, so I suppose exporting to Excel would be easier than with Hysys
#17
Posted 07 September 2013 - 05:08 AM
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.
#18
Posted 26 September 2013 - 04:02 AM
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
#19
Posted 26 September 2013 - 10:56 PM
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
#20
Posted 27 September 2013 - 05:26 AM
Thanks Bod,
I was making some mistakes on the code.
It is now running.
Sacarove
#21
Posted 30 September 2013 - 04:23 AM
Dear All,
I am having an Out of range error on the code below:
#22
Posted 18 November 2013 - 09:19 AM
Dear all,
i want to fetch a value from the spreadsheet I have in hysys.
How the vba code would look like?
Thanks
Sacarove
#23
Posted 12 December 2013 - 03:30 AM
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.
#24
Posted 15 December 2013 - 06:02 AM
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.
#25
Posted 03 April 2015 - 04:01 AM
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
Similar Topics
Aspen Hysys - Creating A New Component And Defining PropertiesStarted by Guest_catiiiii_* , 22 Apr 2024 |
|
|
||
How To Find K-Values Of A Hydrocarbon Mixture On Aspen Hysys?Started by Guest_Alexis Azamar_* , 08 Apr 2024 |
|
|
||
Extension Reaction Kinetic In HysysStarted by Guest_Ulbert Zsolt_* , 29 Mar 2024 |
|
|
||
Aspen Custom Model Won't Load Into HysysStarted by Guest_SaintLazarus_* , 21 Mar 2024 |
|
|
||
Aspen Hysys SimulationStarted by Guest_amazingspidermean_* , 18 Mar 2024 |
|
|