Hysys - Excel link, BackDoorVariable

[MortenMB]

I am trying to access the Initial holdup composition of a separator in a dynamic simulation. Since it seems that it cannot be done with the VBA functions in Excel, I want to do it with the BackDoorVariable function.

The link to the composition is given by:
FlowSht.1/UnitOpObject.400(V-100)/SepStage.500!:MoleFraction.101.0'

How can I access the separation stage of the separator? My code is:
-------------------------------------------------------------------------------------------------------------------------
Dim hyBD As BackDoor
Dim hyOp As Separator
Dim hyFS As Flowsheet

Set hyFS = Hycase.Flowsheet
Set hyOp = hyFS.Operations.Item("V-100")
Set hyBD = hyOp

Set hyBDvar = hyBD.BackDoorVariable("MoleFraction.101.0").Variable
---------------------------------------------------------------------------------------------------------------------------
It returns -32767, which is the empty value…The composition contains values, so it should return the composition value.
I think the error is in the: Set hyOp = hyFS.Operations.Item("V-100") , because it doesn’t have the “SepStage” part…Is there any way to include this?

 

[MortenA]

How is your hybd variable defined? I would assume that it should be some kind of array (im not sure how the compositions are define - but there must be a list of components and their corresponding values)?

 

[MortenMB]

Hi!

I can't use this code =/ It seems I have to initialize from products, so just ignore the question.
But thanks for the response, I appreciate it!