OK, I just tried your version 10 for the first time
The Keysight I/O library was installed, so the USB adapter was found without problems
As soon as I opened up your Excel file and enabled editing and hit start, all worked well and the collection of data started.
No changes made to the settings
A few observations so far:
- Once in a while I get "Syntax Error" listed in the Last Error Message but then it continues with the next reading
- Every time I hit the start button, the first reading is copied to the Error Registry (decimal): spot and just stays there.
- If I set the NPLC: to 100 the software hangs and does nothing and does not recover and requires a restart of the Excel Macro
- In your Value column I see a value with lots of additional zeros and a wrong decimal place
- Current Value is not showing any value, just ####
Improvements request
- Can you add to log the internal temperature with each reading
- Can you leave a field to add a string during initialization, may be just below the NPLC entry?
In general it seems to be a great way of storing the data from the 3458A
I get the same syntax problem with last message......I'm just passing on what the library gives me so need to look deeper.
The next version will update the error register every time. At the moment it only reads it at the start.
large NPLC like 100 is a problem I have yet to get to. There's an issue with trying to talk to the 3458a whilst it's 'busy' and I've yet to bottom this out. For now, if you set a high NPLC then just make sure your sample time set is greater than the NPLC time.....albeit I haven't tried that.
Assuming you set 10vdc the 3458 responded with E+01 which means a x10 multipier needs set on the string...thus you should see 10.0nnnnn.....not sure why it's not processing properly for you. Will do some more testing.
Would be nice to know what you get for 0.1v, 1v ranges etc.....
The #### on current value is just because the string is too long for the cell.......because of above problem.
Not sure what you mean by add a string during initialization?
Ian.