User manual

Using@aGlancewithExcelA-10
SIMATIC PCS 7 OSx 4.1.1 @aGlance
A.3 Using the @aGlance Cold Link Functions
Consider th e guidelines below as you use the Excel add- in macros to create
cold links to the process.
 When you display a macro function you must fill in the function fields
before executing the function.
 For fields that do not require ranges, you can either type the data
directly in the field or click a cell containing the appropriate data. In
the example shown in Figure A-6, select the ServerName field and
either click cell A3 o r type in the server name directly.
 For fields that are identified as ranges, click the spreadsheet cell, or
range of cells, that contains the data that must go into the field. Excel
places the cell reference, not the data, in the field. In the example
shown in Figure A-6, select the OutputRange field and drag the cursor
on cells C3 to E5.
 Although most fields contained within brackets are optional, this is not
invariably true for OSx. Fields that are not optional are identified
within the text of this manual. In Figure A-6, the AttrRange field
appears in brackets, but it is not optional for OSx.
 When you are using the macro tool, hot links that you have configured
on that spreadsheet do not update until you close the macro tool.
 If you need help, click the
Help button. Be sure to refer to the function
description in this manual for differences in how OSx handles the
function.
 If you have trouble with a particular command, first check all tag and
attribute names using the available macro tools, such as
Get Tags and
Get Attributes.
Some Guidelines