I'm working on a macro that pulls in text from an XML document. I am trying to combine several elements of the XML file into one string with line breaks. Combining them into one string works great, however I cannot get the line breaks to work. Here is what I have tried:
Object.Text = "Writer: " & DesktopX.ScriptObject("Comic_Window").Writer1 & "/nArtist: " & DesktopX.ScriptObject("Comic_Window").Artist1
and
Object.Text = "Writer: " &
DesktopX.ScriptObject("Comic_Window").Writer1 & "<br />Artist: " &
DesktopX.ScriptObject("Comic_Window").Artist1
Both examples type out the line break code in the text box. I believe it is not evaluating this string for any html script. Is there something I can do to break this string into multiple lines?
Thanks,
Greg