Reads the value of a property on the workbook, sheet, cell, or selection.
Syntax
|
CHGVAR |
VAR(&CMD) VALUE('XLGETPROP') |
|
CHGVAR |
VAR(&PARM1) VALUE('Property') |
|
CHGVAR |
VAR(&PARM2) VALUE(' ') |
|
CALL |
PGM(LNCCMD) PARM(&HANDLE &CMD &OPT &PARM1 + &PARM2 &RESULT) |
Parameters
|
Parameters |
|
|
Parm1 |
Full path to the property to read. Example : ActiveCell.Font.Color |
|
|
|
|
RESULT |
Receives the property value after calling.
|
Example
Suppose the following cell is activated:
After running the following command:
|
CHGVAR |
VAR(&CMD) VALUE('XLGETPROP') |
|
CHGVAR |
VAR(&PARM2) VALUE('ActiveCell.Font.Color') |
|
CHGVAR |
VAR(&PARM1) VALUE(' ') |
|
CALL |
PGM(LNCCMD) PARM(&HANDLE &CMD &OPT &PARM1 + &PARM2 &RESULT) |
the variable &RESULT will contain the following value: 255, which corresponds to the color code Red.
As
a reminder, here are the Windows color codes:
See also