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

 
Post new topic   Reply to topic    Pico Technology Forum Index -> Getting Started
Author Message
tecstylian
User
User


Joined: 06 Jun 2008
Posts: 2

PostPosted: Fri Jun 06, 2008 3:55 pm    Post subject: How to get DATA of USB TC-08 in Excel sheet? Reply with quote

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
Back to top
gruntman
Guru
Guru


Joined: 28 Sep 2006
Posts: 96
Location: Garden City, KS USA

PostPosted: Fri Jun 06, 2008 5:09 pm    Post subject: Reply with quote

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
Back to top
tecstylian
User
User


Joined: 06 Jun 2008
Posts: 2

PostPosted: Fri Jun 06, 2008 6:17 pm    Post subject: Reply with quote

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
Back to top
picojohn
Site Admin
Site Admin


Joined: 11 Jun 2007
Posts: 391

PostPosted: Tue Jun 17, 2008 3:50 pm    Post subject: Reply with quote

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
Back to top
Display posts from previous:   
Post new topic   Reply to topic    Pico Technology Forum Index -> Getting Started
All times are GMT
Page 1 of 1

 


Pico Technology topic RSS feed 
Powered by phpBB © 2001, 2005 phpBB Group