Functions for Excel Data Link Variables

The following functions can be used for setting or retrieving report options that refer to the specific processs file:

         GetXLSLinkDataForStreamSummaryTable (VarID As VarID, val) can be used to retrieve the value of excel data link variables specified for the stream summary table.

         SetXLSLinkDataForStreamSummaryTable (VarID As VarID, val) can be used for setting the excel data link variables for the stream summary table.

         GetXLSLinkDataForComponentPropsTable (VarID As VarID, val) can be used to retrieve the value of excel data link variables specified for the component properties table.

         SetXLSLinkDataForComponentPropsTable (VarID As VarID, val) can be used for setting the excel data link variables for the component properties table.

         GetXLSLinkDataForEquipmentContentsTable (equipName As String, VarID As VarID, val) can be used to retrieve the value of excel data link variables specified for the equipment contents table (the argument equipName specifies the equipment name).

         SetXLSLinkDataForEquipmentContentsTable (equipName As String, VarID As VarID, val) can be used for setting the excel data link variables for  the equipment contents table (the argument equipName specifies the equipment name).

         GetXLSLinkDataForProcedureOperSeqTable (procName As String, VarID As VarID, val) can be used to retrieve the value of excel data link variables specified for the procedure activity overview (the argument procName specifies the procedure name).

         SetXLSLinkDataForProcedureOperSeqTable (equipName As String, VarID As VarID, val) can be used for setting the excel data link variables for the procedure activity overview table (the argument procName specifies the procedure name).

 

The argument (varID) is the variable identifier that specifies the variable we want to access and the argument (val) is the variable’s value. The Variable ID that needs to be used for each variable is listed in Excel Tables Data Link Variables. Please, see Accessing Pro-Designer Variables with COM for general information on accessing the Pro-Designer variables with the COM server.