User manual

Technical reference 34
Copyright 2004 Pico Technology Limited. All rights reserved.
3.4.4 Excel
The easiest way to transfer data to Excel is to use the PicoLog software application.
If, however, you need to do something that is not possible using PicoLog, you can write an Excel macro
which calls
usbtc08.dll
to read in a set of data values. The Excel Macro language is similar to
Visual Basic.
The example
USBTC0832.XLS
reads in 20 values of the cold junction temperature and channel 1
temperature, one per second, and assigns them to cells A1..B20.
3.4.5 LabVIEW
While it is possible to access all of the driver routines described earlier, it is easier to use the special
LabVIEW access routine. The
usb_tc08.llb
library in the DRIVERS sub-directory shows how to
access this routine.
To use this routine,
copy usb_tc08.llb
and
usb_tc0832.vi
to your LabVIEW
user.lib
directory. You will then need
usb_tc08
sub-vi, and an example sub-vi which demonstrate how to use
them. You can use one of these sub-vis for each of the channels that you wish to measure. The sub-vi
returns a temperature for thermocouple types.
3.4.6 Visual Basic
The
DRIVERS
directory contains the following files, created in Visual Basic 6:
USBTC0832.VBP
USBTC0832.BAS
USBTC0832.FRM
USBTC0832.VBW
3.4.7 HP-Vee
The example program
usb_tc08.vee
shows how to collect a block of data from the
usb_tc08
.
There are prototypes in
USB_TC08.vh
.