I'm not sure if this is the correct section for LCR devices but I saw this device in another post under multimeters.
I am trying to program the E4980A LCR to read inductance/DCR measurements in Lp-Rdc mode and place the results in an excel spreadsheet. Many measurements would need to be taken so upon the next reading it should place this new information in the same columns, one row down. One column for inductance and one for RDC. Currently I am only capable of switching the measurement mode, say from Ls-Rdc to Lp-Rdc. I cannot figure out the syntax to take read measurements into VBA variables.
I am currently using code in this format: instrument.writestring (":FETC")
The instrument variable has been defined properly and I can get the IDN values from the device, so that is not an issue. I am using USB for connections and Excel 2010 with VBA.
I have tried using the supplied programs both in the datasheet and the webpage for the device. I can get the handshake macro to work but upon trying to read data it stops.
If clarification is need just let me know.
We don't have a specific LCR Forum. However, my recommendation is to post in the Network Analyzer section -- the Network Analyzers and LCR meters are both component analyzers and managed by the same Agilent Division.