Can Excel control a scan, and make and record measurements using the 34970A?

Use the following to control the 34970A in Microsoft® Excel (and other environments). IntuiLink for the 34970A This is a free add-in for Excel that places the "Keysight 34970A DataLogger" toolbar into Excel. Use the toolbar to connect to the 34970A, and setup and execute a scan. The returned readings are entered directly into an Excel Worksheet. Several example Worksheets are included with IntuiLink. Download the add-in from this link: Keysight 34970A IntuiLink for Excel IntuiLink is only supported using the GPIB Interface and not RS-232. Instrument Code Wizard The Instrument Code Wizard creates code to control the 34970A and other instruments. For Excel, this code uses the Excel Macro language (a subset of Visual Basic 6.0; see "Excel Macro Language" heading below). The wizard can generate code for the following languages and environments: SCPI Strings only Visual Basic Visual C VEE Excel Macro HP Basic The wizard can create code using the following I/O libraries: Keysight ISDK (AGT3494A Control) VISA COM VISA Keysight SICL NI-488 NI-488.2 You must be familiar with the development environment and programming language to use the sample code. The sample code is intended for GPIB and for a PC that has the GPIB interface installed. Excel Macro Language The Excel Macro language is a subset of Visual Basic 6.0. A macro can be used to communicate and control the 34970A, similar to using Visual Basic. This requires knowledge of Visual Basic programming. To help with programming, several examples are available from the Keysight Developer Network (ADN) website at: Keysight Developer Network (ADN) select the code examples under the "Code Samples" link at the left menu list on the ADN home page. The programs can use either GPIB or RS-232 to control the 34970A. Microsoft is a U.S. registered trademark of Microsoft Corp.