User manual

Using@aGlancewithExcelA-12
SIMATIC PCS 7 OSx 4.1.1 @aGlance
Using the @aGlance C old LInk Functions (continued)
Use the Command function when you need to use the OSx custom functions
Client_Login, Node_Roles,andNull2blank.
Client_Login Use the
Client_Login command (Figure A-7)withthe
Command function when you need to write data to a tag. Use your OSx
User ID and password. A login is not necessary when you only want to read
data.
 ServerName field — the prefix osx must appear in front of the OSx
station name.
 Command field — enter the following:
client_login
 InputRange field — if the User ID has a password, select two adjacent
cells; one must contain the OSx User ID, and the other must contain
the password. If the User ID does not have a password, select one cell
for the User ID. To hide the contents of these cells from unauthorized
users, refer to the user documentation for Excel.
 OutputRange field — OSx does not use this field for the
Client_Login
function.
osxstation1
Jean
secrtwrd
A
BC D E F
GH
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
@aGlance/IT Macro Tool
AAG Functions...
ServerName....
Command...
[InputRange]...
T
ry-it Paste-it Help Close
P
aste-it Cell...
Pause
[OutputRange]....
“Command”
=$B$3
=“client_login”
=$B$4:$B$5
Figure A-7 Client_Login Function
Command