Test and Measurement Forum

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

Having problems ? let us know the details here

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

Postby 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
tecstylian
User
User
 
Posts: 2
Joined: Fri Jun 06, 2008 3:22 pm

Postby 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
gruntman
Guru
Guru
 
Posts: 109
Joined: Thu Sep 28, 2006 3:50 pm

Postby 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
tecstylian
User
User
 
Posts: 2
Joined: Fri Jun 06, 2008 3:22 pm

Postby 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
picojohn
Zen Master
Zen Master
 
Posts: 382
Joined: Mon Jun 11, 2007 1:10 pm


Return to Getting Started

Who is online

Users browsing this forum: No registered users and 0 guests