Agilent E5061B Network Analyzer E5061B Data Transfer Program Operation Manual Rev.01.00 February 2011 Notices The information contained in this document is subject to change without notice. This document contains proprietary information that is protected by copyright. All rights are reserved. No part of this document may be photocopied, reproduced, or translated to another language without the prior written consent of Agilent Technologies. Microsoft®, MS-DOS®, Windows®, Visual C++®, Visual Basic®, VBA® and Excel® are registered trademarks of Microsoft Corporation. Java® is registered trademark of Sum Microsystems Corporation. © Copyright 2011 Agilent Technologies Sample Program The customer shall have the personal, non-transferable rights to use, copy, or modify SAMPLE PROGRAMS in this manual for the customer’s internal operations. The customer shall use the SAMPLE PROGRAMS solely and exclusively for their own purpose and shall not license, lease, market, or distribute the SAMPLE PROGRAMS or modification of any part thereof. Agilent Technologies shall not be liable for the quality, performance, or behavior of the SAMPLE PROGRAMS. Agilent Technologies especially disclaims any responsibility for the operation of the SAMPLE PROGRAMS to be uninterrupted or error-free. The SAMPLE PROGRAMS are provided AS IS. AGILENT TECHNOLOGIES DISCLAIMS ANY IMPLIED WARRANTY OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. Agilent Technologies shall not be liable for any infringement of any patent, trademark, copyright, or other proprietary right by the SAMPLE PROGRAMS or their use. Agilent Technologies does not warrant that the SAMPLE PROGRAMS are free from infringements of such rights of third parties. However, Agilent Technologies will not knowingly infringe or deliver software that infringes the patent, trademark, copyright, or other proprietary right of a third party. 1 1. General information Overview of the program This program (a VBA macro for Microsoft Excel®) transfers the measurement data and the display image from the E5061B to a PC. Supported model and firmware Model Firmware E5061B Network Analyzer Rev. A.02.00 Required equipment • Personal computer * Microsoft Excel® installed (Excel® 2007) * Agilent I/O Libraries Suite 15 or higher installed * Excel Macro File: E5061B_DataTransfer_macro_0100.xlsm • Connection cable (Use either one of the following cables) 1. Agilent 82357A or 82357B USB/GPIB interface 2. USB/USB interface 3. LAN cable (cross or straight cable depending on the connection method) Typeface Conventions Sample Indicates the hard key whose key label is “Sample”. Sample Indicates the soft key whose key label is Sample. 2 2. How to enable macros 1. Open “E5061B_DataTransfer_macro_0100.xlsm” on the PC. 2. Click “Options…” button, then Microsoft Office Security Options dialog box will be displayed. 3. Select “Enable this content” and click “OK” button. 3 3. How to start the program 1. Run the macro by clicking “Run Macro” in the sheet1 as shown in the figure below. 4 4. Operation procedure Connection Method 1. Select a connection method (item 1). 2. Input the address of the E5061B for selected connection method (item 2). Refer to the section 6 “How to confirm the address for each connection method and VISA address” (on page 9) for the checking the address. Connection Method Input Address Example GPIB GPIB Address 17 USB USB ID 2391::2312::MY12345678 LAN IP Address 192.168.xxx.xxx 5 3. Input a VISA interface ID of the connection method (item 3). Refer to the section 6 “How to confirm the address for each connection method and VISA address” (on page 9) for checking the VISA interface ID. 4. Click “Connect” button (item 4). When the “Connected” is displayed (item 5), the connection configuration between the E5061B and the PC is completed. The connection setting will be stored in the excel sheet. The setting will be loaded automatically when you start the macro next time. Save File to Directory 5. If you want to save the measurement result into a separate csv file, check the “Save Data” check box. The file will be saved to the directory selected at “file path” box (item 7) with the file name entered in the “file name input box” (item 10). If you don’t enter the file name, the file will be named as “day_month_year_time” automatically. 6. If you want to save the display image of the E5061B, check “Save Image” box (item 9). The image file will be saved to the directory selected at “file path” box (item 7) with the file name entered in the “file name input box” (item 10). If you don’t enter the file name, the file will be named as “day_month_year_time” automatically. If you want to invert the color of the image file, check “Invert Color” box (item 11). With this setting, the background color of the image will be white. Target Data 7. Select “Data Format” and “Target Trace” (item 12 and item 13). Data Format Formatted Data: The error-corrected data converted to a displayed format such as LogMag, Phase, etc. Corrected Data: The data corrected the errors. (Real and Imaginary format) Both Data: Both of formatted data and corrected data will be transferred Target Trace All: All data of channel and trace will be transferred. Target: The data of specified channel and trace will be transferred. When you choose “Target Trace”, you can select the “Channel” and “Trace” (item 14). 6 State File 8. If you want you save a state file in the external PC, select the save type (item 15) and click the “Export” button (item 16). Save Type Description State Only Save the measurement conditions only. State & Cal Save the measurement conditions and the calibration state. State & Trace Save the measurement conditions and the formatted data array. All Save the measurement conditions, the calibration state and the formatted data array. 9. If you want you recall the state file stored in the external PC, click the “Import” button (item 17). Get Data & End Macro 10. To get the measurement data, click the “Get Data” button (item 18). 11. If you want to end the macro, click the “End Macro” button (item 19). 7 5. The example of the transferred data 8 6. How to confirm the address for each connection method and VISA address GPIB Address Press System > Misc Setup > GPIB Setup, read the Talker/Listener Address on the E5061B. USB ID Press System > Firmware Revision, then Firmware Revision dialog box is appears. Read the USB ID from the dialog box. IP Address Press System > Firmware Revision, then Firmware Revision dialog box is appears. Read the IP Address from the dialog box. VISA Interface ID 1. Run Agilent Connection Expert by double-clicking the icon in the task tray of the external PC. Double click 2. Read the VISA Interface ID from the Agilent Connection Expert. 9 10 7. Revision History Revision Date Description 01.00 2011/02/22 Initial release 11