Macro Comments
•
For simplicity, this macro is designed to output and enter data directly
onto the macro sheet. You may wish to output and enter data on a
worksheet.
•
The macro sheet is divided into the following columns:
A
contains the variable names used in the macro
B
contains the macro commands
C
contains comments about the macro commands
D
place holder
E
contains the SCPI commands to send
F, G, ... contains the returned data
•
The macro takes temperature measurements every 15 minutes for a
12 hour duration, and enters the resulting statistics. Individual
temperature readings are not stored.
•
This macro uses the DATA:FEED command to overcome the 1024
memory reading maximum.
•
The macro uses the CALCulate:STATe OFF and CALCulate:STATE
ON commands to reset the stats for each 15 minute interval. Without
these commands in the while loop, the stats at each interval would be
an accumulation of readings for all measurements.
Chapter 6 Application Programs
Microsoft Excel Macro Example
244
Summary of Contents for 34420A
Page 1: ......
Page 2: ......
Page 13: ...1 Quick Start ...
Page 31: ...2 Front Panel Operation ...
Page 55: ...3 Features and Functions ...
Page 117: ...4 Remote Interface Reference ...
Page 200: ...5 Error Messages ...
Page 213: ...6 Application Programs ...
Page 245: ...6 Chapter 6 Application Programs Microsoft Excel Macro Example 245 ...
Page 246: ...Chapter 6 Application Programs Microsoft Excel Macro Example 246 ...
Page 247: ...7 Measurement Tutorial ...
Page 274: ...8 Specifications ...
Page 279: ...Dimensions Chapter 8 Specifications 34420A Nano Volt Micro Ohm Meter 280 ...
Page 294: ......