I tried to modify each line but I am not getting anywhere, I tried the following:
'Set objSearchResults = Application.Macros(vbldMacroTemporary).Item("TMP_S EARCH_RESULTS")
'strLines = Split(objSearchResults.Value, vbCrLf)
'For Each strEachLine In strLines
' If strEachLine = "Somthing" then
' strEachLine = "SomethingDifferent"
' End if
'Next
'objSearchResults.Value = strLines
The main macro is not geting updated.
|