User`s guide

Table Of Contents

176 Chapter 12

Sample Application Programs

Controlling Using SICL-LAN Server

This section describes how to control the E5061A/E5062A using SICL in the Windows

environment, with a sample program (a VBA macro for Microsoft Excel) written in Visual

Basic. The source file of this program, ctrl_lansicl.xls, is available in the sample program

disk.

NOTE To control the E5061A/E5062A using the SICL-LAN server, you need to make

preparations described in “Control over SICL-LAN server” on page 28.

Using VBA macro

Opening ctrl_lansicl.xls in Microsoft Excel display a screen as shown in Figure 12-3.

Figure 12-3 ctrl_lansicl.xls

For how to use each element in Figure 12-3, refer to the following description.

We begin describing the part 1. In the cell to the right of SICL-LAN Address, enter the

address of the

E5061A/E5062A for control with the SICL-LAN server. This address is

xx, which has been set with the command [System] - Misc Setup - Network Setup -

SICL-LAN Address [xx]

. Enter the IP address of the E5061A/E5062A in the cell right

side of IP Address. This VBA macro will not work properly without appropriate values in

the two cells.

Clicking the button labeled as Preset in the part 2 executes the presetting operation.

In the part 3, sweep range (start and stop points) and number of measurement points for

channel 1 are set. Clicking the button labeled as Set executes the setting as shown in the

setting table.

The part 4 set the measurement parameters and data format for trace 1 in channel 1.