Share via

Application.Replace Method

  • Article
Project Developer Reference

Searches for an unfiltered value and replaces it with the specified value. The Replace method returns True if replacements were made.

Syntax

expression.Replace(Field, Test, Value, Replacement, ReplaceAll, Next, MatchCase, FieldID, TestID)

expression   A variable that represents an Application object.

Parameters

Name Required/Optional Data Type Description
Field Optional String The name of the field to search.
Test Optional String The type of comparison made between Field and Value Can be one of the following comparison strings:
Comparison stringDescription
"equals"The value of Field equals Value.
"does not equal"The value of Field does not equal Value.
"is greater than"The value of Field is greater than Value.
"is greater than or equal to"The value of Field is greater than or equal to Value.
"is less than"The value of Field is less than Value.
"is less than or equal to"The value of Field is less than or equal to Value.
"is within"The value of Field is within Value.
"is not within"The value of Field is not within Value.
"contains"Field contains Value.
"does not contain"Field does not contain Value.
"contains exactly"Field contains exactly Value.
Comparison string Description
"equals" The value of Field equals Value.
"does not equal" The value of Field does not equal Value.
"is greater than" The value of Field is greater than Value.
"is greater than or equal to" The value of Field is greater than or equal to Value.
"is less than" The value of Field is less than Value.
"is less than or equal to" The value of Field is less than or equal to Value.
"is within" The value of Field is within Value.
"is not within" The value of Field is not within Value.
"contains" Field contains Value.
"does not contain" Field does not contain Value.
"contains exactly" Field contains exactly Value.
Value Optional Variant The value to compare with the value of the field specified in Field.
Replacement Optional Variant Use "" (an empty string) to clear Field where it meets the test specified by Test and Value.
ReplaceAll Optional Variant True if all occurrences of Value are replaced. False if only the first occurrence is replaced. The default value is False.
Next Optional Variant True if Microsoft Office Project 2007 searches down for the next occurrence of matching search criteria. False if the program searches up for the next occurrence. The default value is True.
MatchCase Optional Variant True if the search is case-sensitive. The default value is False.
FieldID Optional Variant
TestID Optional Variant

Return Value
Boolean

Remarks

Using the Replace method without specifying any arguments displays the Replace dialog box.

Example
The following example lowers the priority of all tasks from highest to high.

Visual Basic for Applications 
  Sub LowerPriority()
    Application.Replace Field:="Priority", Test:="equals", Value:="Highest", Replacement:="High", _
        ReplaceAll:=True
End Sub

See Also