Yup, VBA at the core.
[QUOTE=Phoenix;35139]Excel..... that's got to be backed by VBA code QUOTE]
Yup. But we cheat a little and use commercially available OPC (based on Microsoft OLE) software. Basically acts a s a bridge between your OPC client software, in this case Excel, and the PLC. But the engine is Visual Basic \ .NET framework.
Since in the lab we're mostly about data collection, a spreadsheet made the most sense. Suppose we could use Access to dress it up to make it more user friendly.
[QUOTE=Phoenix;35139]Excel..... that's got to be backed by VBA code QUOTE]
Yup. But we cheat a little and use commercially available OPC (based on Microsoft OLE) software. Basically acts a s a bridge between your OPC client software, in this case Excel, and the PLC. But the engine is Visual Basic \ .NET framework.
Since in the lab we're mostly about data collection, a spreadsheet made the most sense. Suppose we could use Access to dress it up to make it more user friendly.
Comment