Jump to content

Featured Articles

Check out the latest featured articles.

File Library

Check out the latest downloads available in the File Library.

New Article

Product Viscosity vs. Shear

Featured File

Vertical Tank Selection

New Blog Entry

Low Flow in Pipes- posted in Ankur's blog

Excel Macro Object For Column Feed Stage

hysy export to excel

This topic has been archived. This means that you cannot reply to this topic.
1 reply to this topic
Share this topic:
| More

#1 fydphm


    Brand New Member

  • Members
  • 2 posts

Posted 16 December 2011 - 11:16 PM

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!

#2 Chellani


    Gold Member

  • Members
  • 78 posts

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


Similar Topics