11 replies to this topic

[Vijay_G_K]

Hi,

 

I am trying to extract the content of notes tab of each stream of hysys.

I able to fetch other values of the stream through vba excel but not getting the way to fetch the Notes Tab content.

Below is a part of my code.

Please help on this.

 

Thank in advance.

 

 

 

 

    

    Set hyOperations = hyFlowsheet.Operations

    Set hyStreams = hyFlowsheet.Streams

 

 

 

    For Each hyStream In hyStreams

 

'I want the code to extract content of notes tab for each stream here.

 

 

    Next hyStream

 

 

End Sub

[Bobby Strain]

Try Aspen Tech support site.

 

Bobby

[pavanayi]

Just checked the Hysys object browser. I couldn't find anything related, so I think it is either not available, or not exposed.

[Bobby Strain]

So, you still haven't done as I suggested.

 

Bobby

[Vijay_G_K]

Thanks Bobby,

 

just today I created my username in aspen tech support site.

 

May be I will receive the mail in 2 days as pr there info on site.

[Vijay_G_K]

Just checked the Hysys object browser. I couldn't find anything related, so I think it is either not available, or not exposed.

If it is not in the object browser then how it can be displayed on hysys window. is there any other way to find this "Notes" tab.

Actually while modeling we go on writing the comments in this note tab only, and it becomes very much difficult to summarize all the notes from all the streams or operation object.

 

If it can be done using excel vba it will help me a lot.

 

thanks. 

[Bobby Strain]

Download HSR from the site and you can find the code in there to do what you want. Notes are not exposed in the object model, so you have to use the backdoor approach to retrieve the note. Good luck.

 

Bobby

[Vijay_G_K]

Thanks Bobby for the suggestion.

 

I have the HSR. Actually I learned the Excel hysys link by HSR. But in that no code is related to the "Notes" tab.

 

Backdoor approach I am not aware of. Can u post an example if it is readily available with you.

 

Vijay

[Bobby Strain]

You should search all the code with the search feature. Search for whole word Notes. Seek and you shall find.

 

Bobby

[Vijay_G_K]

Thanks bobby,

 

I got the solution in hsr. although it is verry much tricky but my purpose is solved.

 

Vijay

[pavanayi]

Please note, that back door approach may stop working when a new version is released. (Even though, the methods  I have used have not changed between versions till now, that does not mean it won't in the next release)

[Vijay_G_K]

OK.

 

Although We are using 6.5 which is much latest. and if that script dont work atleast i know the steps how it works.

 

but i will take care of version change. 

 

Thanks

Vijay