Multiline Macro Value
 

Is there a way to read each line, one at a time, from a mutiline macro value.

I cant seem to find an example, any sample you can provide would be appreciated.

Forgot to mention I was trying to do this in VBScript

See attached sample.

Great thanks for the help!!

I tried to modify each line but I am not getting anywhere, I tried the following:


'Set objSearchResults = Application.Macros(vbldMacroTemporary).Item("TMP_SEARCH_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.

Attached.

Thanks again!