How do you manipulate a variable like a file?

I'm pulling Outlook Task items into a spreadsheet and stuffing the bod
of the Task into the cell Comments. This is working great except th
body of the Task holds formating information like chr(13)s. I want t
read through the Task Body variable in memory and remove the chr(13)
before adding the Comment.

If olTsk.Body < "" Then
ActiveSheet.Cells(i, x).AddComment olTsk.Body
ActiveSheet.Cells(i, x).Comment.Shape.TextFrame.AutoSize = True
End If

Any ideas?

Thanks,

Ty

--
Message posted from http://www.ExcelForum.com