TEST RESULTS HANDLING VOLTECH AT3600 USER MANUAL
EXAMPLE OF ON-LINE ANALYSIS
This section contains a simple example to illustrate how you may use OLE to transfer
the measured results into a spreadsheet as they happen in real-time.
The spreadsheet used in the example is Microsoft Excel 97, and the module of code
illustrated is written in the Visual Basic supplied with the spreadsheet.
Before attempting to create the spreadsheet, set up the AT and server:
• Use the editor to create a program containing 5 tests, where test number 3
measures a winding resistance.
• Ensure that the program option ‘Send Results to Server’ is set to ‘On’.
• Transfer the program to the directory being used by the server for storing
programs.
• Ensure that the server program is running, and that the COM Port to be used
has been enabled.
• Connect the AT to the server PC, and use the PROGRAM - SET-UP menu
to set the origin to SERVER.
• At the AT Top Level menu, press the EXECUTE soft-key, and type in the
name of the program.
• Run the program and check that the correct results are displayed in the on-
line monitoring window.
Leave the Server program running, and on the same PC, start Microsoft Excel 97.
A new (empty) spreadsheet will be created.
From the Excel top level menu bar, select:
Tools
Macro
Macros
Enter the name ‘OLE_Demo’ and then create.
Excel will then bring up a module sheet labeled ‘Module 1’. Type the following code
into this module sheet:
'*************************************************************************
'OLE_Demo Sub
'
'Procedure to demonstrate linking AT results into an Excel spreadsheet
'in real time using OLE.
'
'The procedure will read the third test in the program and put the result
'into a cell on the third row of the spreadsheet.
PAGE 4.3.28. VPN 98 - 024 USING THE SERVER
To Next Page
Loading...