how to use =ABBGetOPCHDA formula to get an array of Time stamp,Value and quality is excel.
I am tring to run =ABBGetOPCHDA formula to make templates for log reports.
Formula runs , but in one cell only.
Please suggest how to make it give me a table which contains Time stamp, value and quality in 20 columns for one tag.
For the remaining audience.
Start off by using the "function wizard" by clicking the corresponding button on the Data Direct toolbar and be sure to select "Paste Formula"
After completing the wizard you will hopefully be able to retrieve some logged data and also realize that you need to put the formula over a selection of rows and columns to allow the data to be output.
The trick when using the ABBGetOPCHDA() function manually is to learn how to paste a formula over a selection of cells, not just one.
=> Mark output cells, write ABBGetOPCHDA()-function, then you need to press and hold the CTRL+SHIFT keys and finally hit the ENTER key to put the formula in effect over the selection.