Requirement for flag of archive value - example

DDE reference:

= D_2000|ARCH_FLAGS!WB1_Blok2_10

It requires the status of 10th value. This reference can be called only from workbook with a logical name WB1.

DDE reference returns the string that contains all flags of 10th archive value from the archive block WB1_Blok2. The value must be TRUE. For example, if DDE reference returns the string "AB;", the flags A and B of archive value are TRUE. The function IsFlag can be used to get the value of the particular flag:

= IsFlag(D_2000|ARCH_FLAGS!WB1_Blok2_10,"A")

This function returns the value of A flag (tenth) from archive block WB1_Blok2.