Tektronix Technical Forums are maintained by community involvement. Feel free to post questions or respond to questions by other members. Should you require a time-sensitive answer, please contact your local Tektronix support center here.

2182A via RS-232 into Excel

2182 Series Support
Post Reply
laecus2580
Posts: 4
Joined: September 9th, 2014, 6:43 am
Country: United States

2182A via RS-232 into Excel

Post by laecus2580 » September 9th, 2014, 8:35 am

I am trying to use Excel VBA to read and store data from the 2182A, but I am having trouble with reading data. I have tested successfully using the "*IDN?" command, but ":READ?" is giving me trouble. Are there any resources available discussing the use of Excel and instruments like the 2182A?

Dale C
Keithley Applications
Keithley Applications
Posts: 2842
Joined: June 10th, 2010, 6:22 am
Country: United States
Contact:

Re: 2182A via RS-232 into Excel

Post by Dale C » September 9th, 2014, 12:05 pm

When you use *IDN? , do you receive the identification information back?
If you do, then you do the same thing with :READ?
Can you send any other commands to the 2182A via RS-232?

laecus2580
Posts: 4
Joined: September 9th, 2014, 6:43 am
Country: United States

Re: 2182A via RS-232 into Excel

Post by laecus2580 » September 9th, 2014, 12:36 pm

With *IDN? I do get a correct and full response.

Other commands appear to be successful, such as ":SENS:FUNC 'VOLT'" and ":SENS:CHAN 1". Are there other query commands I should try?

Dale C
Keithley Applications
Keithley Applications
Posts: 2842
Joined: June 10th, 2010, 6:22 am
Country: United States
Contact:

Re: 2182A via RS-232 into Excel

Post by Dale C » September 9th, 2014, 1:11 pm

If that is the case then try
*RST
:READ?
That should reset the Model 2182A and give up one reading.

laecus2580
Posts: 4
Joined: September 9th, 2014, 6:43 am
Country: United States

Re: 2182A via RS-232 into Excel

Post by laecus2580 » September 9th, 2014, 1:23 pm

I get ERRO-110

laecus2580
Posts: 4
Joined: September 9th, 2014, 6:43 am
Country: United States

Re: 2182A via RS-232 into Excel

Post by laecus2580 » September 9th, 2014, 1:43 pm

I think I have found my issue. I was not correctly sending the CR to terminate the command, whereas with the *IDN? I was adding a ;. However, with each :READ? I still get ERROR-213. Is there a way to eliminate that error or the associated beep?

Dale C
Keithley Applications
Keithley Applications
Posts: 2842
Joined: June 10th, 2010, 6:22 am
Country: United States
Contact:

Re: 2182A via RS-232 into Excel

Post by Dale C » September 11th, 2014, 6:34 am

Error -213 is INIT IGNORED.
The READ? command contains the INIT.
Send *RST at the beginning of the program to place the unit in IDLE. Then a READ? will work without the -213 erro.
OR
If the unit is updating then just send a FETCH? instead of the READ?

Post Reply

Return to “Nanovoltmeters”

Who is online

Users browsing this forum: No registered users and 4 guests