I am using a vbscript to read the event log and dump the information into a text file. I will be importing the text file at a later date into Excel or elsewhere.
the important bits of code is below, however it doesnt appear to be working. The below gets rid of the majority of line breaks but still leaves some behind and it shows in Notepad as a little square (see attached image) but when looked at through notepad++ or excel it does as below and uses a new line
"The memory could not be "read"
Click on OK to terminate the program"
Is there any way to get rid of these line breaks, where have I gone wrong in my code?
Details = objevent.message
Details = Replace(Details,vbCrLf,"")