Importing to Excel

Post general discussions on using our drivers to write your own software here
Post Reply
Posts: 4
Joined: Wed Jul 26, 2006 8:55 am

Importing to Excel

Post by GHaines » Thu Aug 31, 2006 10:06 am


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.



Post by 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 requesting them and we will send them to you.

Best Regards

Post Reply