1 reply to this topic

[fydphm]

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!

[Chellani]

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