Thanks, I'm afraid this problem was only solved for a while, I'm still having a few problems, hope you can help?
I wrote my own spreadsheet (attached) based very closely on PS3000aV2.xlsm.
This program is giving strange results and your PS3000aV2.xlsm now crashes when run.
I cannot get the unit to properly exit from ps3000ASetSimpleTrigger(). Upon exiting ps3000aSetSimpleTrigger() the IsReady() function only returns zero saying that the device is never ready again.
Also, I'm using the document PicoScope3000SeriesAApiProgrammersGuide.pdf for reference, this tells me the enumerated value names but doesn't tell me the values that they are enumerated to, should I be reading a different document?
The example gives the voltage range 8 to be ±5V, does this mean that the range of values is 2 to 10? In the attached spreadsheet, I am using the following line to determine the range of the number that's passed (from cell C40) is this correct?
=IF(C40=2,"±50 mV", IF(C40=3,"±100 mV",IF(C40=4,"±200 mV",IF(C40=5,"±500 mV",IF(C40=6,"±1 V",IF(C40=7,"±2 V",IF(C40=8,"±5 V",IF(C40=9,"±10 V",IF(C40=10,"±20 V")))))))))
After ps3000aGetValues() the returned status value is 37, I don't know if that helps.
To run my spreadsheet program, after looking at the values please click on the buttons in order, 1) Clears the values in the table that are populated by VBA, 2) gets the scope data, then scroll so that the count is visible (ie row 80 is on the screen) then press 3) to get the data.
Hope you can help?
- Based closely on PS3000aV2.xlsm
- (67.67 KiB) Downloaded 30 times