Also see HLP1080, a. - USC701 And Data Acquisition
The ActiveX component is available from the link below. It
provides all necessary data conversion to read USC701 data
directly through the AM702 / COA703 connection on the top
of the module.
WARNING Do not connect directly to the top of the USC701 a
COA703 must be used.
The 'apcscoa.ocx' ActiveX control can be used with popular MS office applications such as EXCEL to directly read USC701 data. Various programing languages can also directly use ActiveX components. Multiple USC701 modules can be connected at a time, however this will require multiple COA703 and RS232 serial ports.
Downloads
- Free COA703 ActiveX Control (updated 19/05/2005 problems encountered)
- Windows test program with VB5 source code
EXCEL Demonstration
This demonstration assumes that CH1 on the USC701 is programmed and sending messages. The CH1 event procedure is used in the example, the principle applies to the other channels and memories.- Down load and install the ActiveX control
- Start Excel and open a new blank workbook.
- Turn on the 'Control Toolbox' if not already displayed, ('View' > 'Toolbars' > 'Control Toolbox'
- Click 'More Controls' (Hammer + Scanner icon)
- Select 'APCS_Read.COA'
- Place object by dragging on screen over the area to display then adjust to required size.
- In CELL A2 type 'CH1' and in 'B2' type 'Read Time'
- Right click on the object placed earlier an select view source code
- Enter the code as shown below. To enter code in the declorations
section above the event procedure for CH1 select general
on the left drop down menu.
- Select 'File' . 'Close and return to Microsoft Excel.
- On the control tool bar click the
design button up to return to run mode. - Connect COA703 to serial port and a operating USC701.
- Click 'COM' and select the required number.
- Click 'Open' measurement should be displayed.
