Multiline Macro Value

[HippyCraig]

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.

[HippyCraig]

Forgot to mention I was trying to do this in VBScript

[kinook]

See attached sample.

[HippyCraig]

Great thanks for the help!!

[HippyCraig]

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.

[kinook]

Attached.

[HippyCraig]

Thanks again!