PicoScope 7 Software
Available on Windows, Mac and Linux
Using Excel to collect data from a USB port
-
Henrik H. M.
Using Excel to collect data from a USB port
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?
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?
-
Henrik H. M.
A few questions more about collecting data from a USB port
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
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
-
Sarah
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
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