We have migrated Excel reports used to enter Historical Data Entry of Lab Data. To present the last entered lab value to the Operator screen, the report also executed an OPC DA write to variables in a module, which would then be shown in an operator screen.
With the new Add in, the function to write programmatically no longer works. We would like to select a group of cells that are configured to write to specific parameters and fire off the Write command, expecting that the confirmation dialog will appear. In this way, the Operator or lab technician enters data in the appropriate cells, and presses the Write Button. This executes the HDE writes (no problem there), and then fires off the function to write the same data to a module.
The Excel Addin has been rewritten in v13.3.1 but the method to trigger a write is hidden. We tried loading the Excel Addin from v12.3.1, but it requires two additional Addin's that we do not have.
Does anyone know if the syntax to execute writes as a function or method we can call from the EXCEL VBA code?
Andre Dicaire
Andre,
What was the version of DeltaV prior to the migration? Per AC-1400-6244 the DVWrite function is no longer exposed to the user through the Excel Reporter Add-in. The prior VBA code library was deemed less secure and was hidden from user custom code starting with the v12.3.1 rewritten edition of the add-in.
Ben
In reply to Ben Bishop: