Hi. Two Questions.
1.)Does anyone know where to get Explanations for the USBADC11 Driver Routines? The only ones I can find are for the adc11, I have used these descriptions but have a few problems with my software and would like the usbadc11 descriptions.
2.) I was happy writing small programs for EXCEL and the DR DAQ. But now writing for the USBADC11, Nothing seems to work well/consistently, I think part of the problem is the only example I have is the PICO one contained in the examples directory and this seems to not work as often as does, never works twice and needs the ADC11 de-powering to get it to work again. So please if anyone know or has any USBADC11 excel progs I could look at please could you give me the link?
The Excel example in the SDK should work fine. If you are having intermittent problems, I would test the unit using the PicoLog software. If you still have problems, contact technical support: support@picotech.com
Yes I can run picolog, happily logging data for days on end using the same hardware as well. I am running R 5.20.9! The example usbadc11.xls will run once fine then if i run the macro again it just loops somewhere, no red LED on the ADC11 and excel just hangs, when I unplug the usb lead to the ADC11 Control is returned within Excel and the macro returns the "Unable to open ADC" string. I have played about trying to make the thing work but nothing I have tried works. I have have tried to interogate the device with UsbAdc11GetUnitInfo but all it ever returns is the serial number of my ADC11! Of course as I have no description ot the UsbAdc11 routines i may well not be using it right.
I have also done a few other measurements expanding on the example but all will work the first time but not after.
Er Sorry Robin. I did not need to be logged in to post, I am not logged in! I have not registered either. Would it be possible to just type the link in without making it a hyperlink? Or will I need to register?
I have contacted you through Email wrt the example file. I think I have solved most of the problem now however. I tried the macro on another computer ( One I might add I do not data log on normally because it does not run picolog so well!) Anyway the macro will run quite happily as many times as I want. The problem I suspect is that the machine that runs the Macro has Office 2003 on it and the one that hangs has Office 2007 on it. If I get the time I will try and prove it.
But the usbadc11.xls Macro although going through the motions is not updating the data in Excel after its first run! It fills the cells nicely with time and readings the first time you run it but if you then clear these cells the next time you run it nothing is put into the cells but the info indicating the unit opened OK is correctly outputted.
If the Line.
nValues = UsbAdc11GetTimesAndValues(handle, times(0), values(0), 100)
is replaced with
nValues = 100
Then the data collected the first time the macro was ran is outputted into excel again.
Thankyou for the copy of the usbadc11.xls file. I extracted it and used it on the PC running Office 2003 and it worked correctly as many times as I cared to! The macro GetAdc11 is Identical in the copy that you provided and works and the One I was using and does'nt!!
The Copy of usbadc11.xls however still does not work and acts as described above on the machine with Office 2007 on it?
Anyway I am happy now and will persevere on the PC with Office 2003 on it, maybe the problem is Office 2007 running in compatability mode for usbadc11.xls, or something but I shall not br exploring it any further.
Is there any descriptions of the USBADC11 Driver Routines available?
Thankyou very much for all your good work and help, Robin and Ziko.
and a Merry Xmas to you and all at Pico.
Could it be that macros are not enabled in Office 2007? In terms of the driver description, we do not have any documentation on this. However these are very similar to the parallel ADC11 which do have documentation. The programming examples we have will have a list of all the function calls in one of the header files (USBADC11Api.h).