Hi everyone,
My problem is very straightforward. I want to export the feed stage number of a distillation column from HYSYS to excel, but I don't know what object I should select when I'm coding the macro. Any suggestions?
Thank you very much!
|
Excel Macro Object For Column Feed Stage
Started by fydphm, Dec 16 2011 11:16 PM
hysy export to excel
1 reply to this topic
Share this topic:
#1
Posted 16 December 2011 - 11:16 PM
#2
Posted 01 January 2012 - 03:33 AM
My knowledge in this is area is pretty poor but getting most of the variables is possible.
When I search for ‘feedstage’ using object browser in HYSYS library it shows, class as _TraySection and member as FeedStages but TraySection class is somehow hidden (I don’t know what that means in VB). If you can use this, task should be very straight forward.
Few variables are actually not exposed in OLE but most of the variables are exposed in script manager. To combine power of two methods, record a simple script using script manager which will give you monikers and call these monikers using backdoor entry in VB. Again I don’t know exactly how this is done (OLE part, scripting is pretty straight forward) so can’t write code for you. Probably below link may help you
http://www.eng-tips.....cfm?qid=169881
When I search for ‘feedstage’ using object browser in HYSYS library it shows, class as _TraySection and member as FeedStages but TraySection class is somehow hidden (I don’t know what that means in VB). If you can use this, task should be very straight forward.
Few variables are actually not exposed in OLE but most of the variables are exposed in script manager. To combine power of two methods, record a simple script using script manager which will give you monikers and call these monikers using backdoor entry in VB. Again I don’t know exactly how this is done (OLE part, scripting is pretty straight forward) so can’t write code for you. Probably below link may help you
http://www.eng-tips.....cfm?qid=169881
Similar Topics
Diked Area Around Distillation ColumnStarted by Guest_hysyshunter_* , 15 Apr 2024 |
|
|
||
Distillation Column Decommissioning ChecklistStarted by Guest_m.bhut_* , 08 Apr 2024 |
|
|
||
Distillation Column DiameterStarted by Guest_refluxraider_* , 12 Mar 2024 |
|
|
||
Diameters Of A Structured Packing Distillation Column With No VapourStarted by Guest_hysyshunter_* , 07 Mar 2024 |
|
|
||
Distillation Column With TraysStarted by Guest_wait_what_* , 13 Feb 2024 |
|
|