XLREPLACE command

Find and replace text in the current Excel workbook.

Syntax

CHGVAR	VAR(&CMD) VALUE('XLREPLACE')
CHGVAR	VAR(&PARM1) VALUE(' ;Find="Searched text" ;ReplaceWith="Replacement text" [;MatchCase] ')
CHGVAR	VAR(&PARM2) VALUE(' ')
CALL	PGM(LNCCMD) PARM(&HANDLE &CMD &OPT &PARM1 + &PARM2 &RESULT)

Parameters

Parm1

Find is the text you are looking for.

ReplaceWith is the replacement text.

MatchCase indicates that the search will be case-sensitive.

Example

LNCCMD CMD(XLREPLACE) PARM1('Find="Aura";ReplaceWith="Equipements"')

Look for cells containing "Aura"/"aura" and replace "Aura"/"aura" with "Equipements".

LNCCMD CMD(XLREPLACE) +
PARM1('Find="Aura";ReplaceWith="Equipements";Matchcase')

Search (case sensitive) cells containing "Aura" and replacing "Aura" with "Equipements".

See also

• XLFIND