800xa report template
My best compliments
I will prepare a template in Excel for report. First of all I start with ABB avaliable template under non-batch report template hourly log. However avaliable macro gives a error. Tag01 is exist in action ascpest parameter list. I attached error screenshot.
Voted best answer
Instead of using template, try a blank (empty) Excel spreadsheet and the different OPC DA/HDA "wizards" from the DataDirect plugin menu.
Start from the left; skip "Login" (only required when using IM dependent function like ABBSQL(), etc). Next after login is the ABBGetOPCDA() function wizard, next is ABBGetOPCHDA(), ABBAERetrieval(), etc.
Its not that hard to read a live value, a history log or alarm/event list. Please note that the wizard can insert data, or formula. The later is great when discovering how a report template is made.
After doing this, I believe you can reverse engineer the error you get with the ready made template; eg object path (_Tag01) is set incorrect to an incorrect value. Proper syntax is OBJECT:ASPECT:PROPERTY. Object can be path or name; path can be omitted if name is unique.
Biggest hurdle is usually how to crack how a function in Excel can be set to return data to more than one cell... need to use ALT-CTRL-SHIFT (search Google...).
Also; don't forget to set sheet with MANUAL calculation mode. Then force recalculate with ALT-CTRL-SHIFT-F9.
Also, have a look at the IM Data Access and Reports User's Guide. It covers it all, even the non-IM dependent functions like ABBGetOPCDA(), etc.