How to get DATA of USB TC-08 in Excel sheet?

tecstylian · Post by **tecstylian** » Fri Jun 06, 2008 3:55 pm

I am quite new to data acqusition and programming. I need to get the temperature data on my excel sheet by using USB TC-08 device.

I open the file usbtc0832 via the following path
C:\Program Files\Pico\Drivers\Win32

To run this macro I clicked at OPEN button and I get the following error.

Run-Time Error '53'
File not found c:\usbtc08.dll

Pls let me know step by step how can I get the data on Excel sheet.

Thanks in Advance

gruntman · Post by **gruntman** » Fri Jun 06, 2008 5:09 pm

Tecstylian,

The program is simply referencing the driver in its wrong location. You can either simply copy the usbtc08.dll from your Pico folder to c:\usbtc08.dll or change the macro so its reads the correct location. After you do these steps you will resolve this error.

Regards,

Richard Boyd
Crag Technologies, Inc
http://www.pc-oscilloscopes.com

tecstylian · Post by **tecstylian** » Fri Jun 06, 2008 6:17 pm

Thanks for your prompt reply.

I did the same as you said. There are two files named as usbtc08.dll. I have placed one by one But it didnot work.

First file (sized 111KB,)
Initially located at C:\Program Files\Pico\Drivers\Win32
when placed in C:\ and instructed to run in Excel
It just hanged the Excel file so in the end I have to stop it via task manager and by detaching TC-08 from USB port.

Then 2nd file (sized 148KB, Version 1,7,0,0)
Initially located at C:\Program Files\Pico Technology\Pico Full
when placed in C:\ and instructed to run in Excel
It gives the following error
Run-time error '53'
File not found c:\usbtc08.dll (ByVal handle As Integer, temp As Single, ByRef overflow_flags, ByVal units As Byte) As long

Kindly put some light on it.

Thanks

picojohn · Post by **picojohn** » Tue Jun 17, 2008 3:50 pm

Hello tecstylian,

You could run PicoLog and export the data from the spreadsheet view.

Section 3.8 of the user guide explains how (http://www.picotech.com/document/pdf/plw044.pdf).

Regards
John