Test and Measurement Forum

Importing to Excel

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

Importing to Excel

Postby GHaines » Thu Aug 31, 2006 10:06 am

Hello,

I am using an ADC-20 and TC-08 to measure six variables and at the moment, after recording them using pico log, i manually copy and paste them to Excel for analysis. Is the a way to automatically import the data into Excel? It would be nice to do this in real time but I would be satisfied with just importing the data after recording has taken place. I guess that I could use a macro to do this but I do not know anything about macros and have very little programming experience. Any help would be much appreciated.

Thanks,
Gareth
GHaines
User
User
 
Posts: 4
Joined: Wed Jul 26, 2006 8:55 am

Postby Sarah » Thu Aug 31, 2006 10:19 am

Hi Gareth

Thank you for your post.

There are 2 main ways to do this. You can use a VB macro to directly control the unit, or you can use a DDE example to get the data live from Picolog. The VB macro is available by doing a custom installation of our software. If you would like the DDE examples then please email us at tech@picotech.com requesting them and we will send them to you.

Best Regards
Sarah
 


Return to General Software Discussions

Who is online

Users browsing this forum: No registered users and 0 guests