Using Excel to collect data from a USB port

 
Post new topic   Reply to topic    Pico Technology Forum Index -> General Software Discussions
Author Message
Henrik H. M.
Guest
PostPosted: Tue Mar 15, 2005 11:11 am    Post subject: Using Excel to collect data from a USB port Reply with quote
Hi!

We have four ADC11 connected to USB ports. To collect data from them we are trying to use Excel.

This is the first time we're trying to set up a macro in excel and we've run into a few problems when looking through your example.

First how do you refere to a USB-port instead of the LPT1?

We want to make continious loging from them, and it should be possible to follow the measurements "live" through the excel sheet as they are made. How is this set up the easiest?

Do you have to open and close each port each time, or is it possible to log on all four ports at the same time, and if how?

Another possibillity could be to be able to make eg. 128 measurements instead of only 64 in the program PicoLog, Could this be made?
Back to top
Henrik H. M.
Guest
PostPosted: Tue Mar 15, 2005 8:23 pm    Post subject: A few questions more about collecting data from a USB port Reply with quote
Hi again

we've read in one of the asked questions in this forum ("Wed Nov 03, 2004 11:47 am Post subject: Excel logging with ADC-11") that the excel macro wont run more than one run at the time and then it should be closed down. We have also experienced this, and also tryed to close the port with the command for this procedure in the macro (we are not using the right port as described above, but still it could give us some problems). Is this problem fixed, and if how? If it isn't fixed how is it then possible to make measurements on more than one ADC11?

Best regards
Henrik
Back to top
Sarah
Guest
PostPosted: Thu Mar 17, 2005 11:14 am    Post subject: Reply with quote
Hi

Thank you for your post.

Firstly, The port numbers for the ADC11 when on USB, or the USB ADC-11 is 101, 102, 103, 104.

For the continuous logging you would need to use streaming with the ADC11, this only works on USB and you would need to write your own software.

It is possible to use more than one ADC-11 at a time on USB, to swich
between them you will need to call the adc11_set_unit function.

With regards whether the Excel Macro now works, the best way to check this is to download the latest one. If it is still not fixed then let me know.

Hope this helps

Best Regards
Back to top
Display posts from previous:   
Post new topic   Reply to topic    Pico Technology Forum Index -> General Software Discussions
All times are GMT
Page 1 of 1

 


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