sample excel macro provided with PicoLog

Post general discussions on using our drivers to write your own software here
Post Reply

sample excel macro provided with PicoLog

Post by Guest » Wed Jul 21, 2004 10:45 am

I notice that the PicoLog software comes complete with a separate macro for reading data straight into Microsoft Excel. I would like to utilise this feature but using type J thermocouples instead of K.

I looked in the visual basic code and would be obliged if you could confirm the following

"Call tc08_set_channel(Port, 1, Asc("K"), 10, 0, 0)"

Presumably changing the K to a J would enable a type J thermocouple to be used?

"If ok Then
Cells(i + 3, "C").value = temperature / 100"

This is the equation for reading the temperature into excel. Does this equation change for a type J thermocouple?

To read from more than two channels could the following code be used?

"Call tc08_set_channel(Port, 3, Asc("J"), 10, 0, 0)"
"If ok Then
Cells(i + 3, "D").value = temperature / 100"

or is the maximin number of channels usable with your macro only two?

User avatar
Site Admin
Site Admin
Posts: 598
Joined: Wed May 07, 2003 9:45 am

Post by markspencer » Thu Jul 22, 2004 8:25 am


Thank you for your post.

It is possible to use all 8 channels in the excel macro by calling the tc08_set_channel routine. You are correct in your assumption that changing the 'K' to a 'J' will indeed inform the driver that the thermocouple that you intend using on this channel wil be a J type thermocoupl. You do not have to have all the same thermocouples on the channels eg channel 1 may use a J type, and channel 2 a K type etc.

You asked about the following code this will place the data after the variable temperature has been divided by 100 in to row i+3, and column C. To get the reading into temperature variable you will need to us the routine tc08_get_temp.

Best regards,

If ok Then
Cells(i + 3, "C").value = temperature / 100"

Mark Spencer

Post Reply