I would advise you to look at our examples in both VB and the examples for Excel. This will give you a very simple example of collecting data, as a temperature reading and in milliviolts. This example will have function calls to the driver they can be identified by the TC08_ at the start of the functions name.
Read the help manual under 'Writing your own software', this will explain the parameter types. You may also find a book on VBA usefull as well.