VBA: Debug.Print without newline?
It turns out you can easily do this by simply adding a semicolon to the end of your Debug.Print
statement. Like so:
While oExec.StdOut.AtEndOfStream = False sLine = oExec.StdOut.ReadLine If bInFileSystem Then If AnalyzeFileSystemLine(sLine) = False Then Debug.Print "[FSERR]: "; End If ElseIf bInWASCheck Then If AnalyzeWASLine(sLine) = False Then Debug.Print "[WASERR]: "; End If End If Debug.Print sLineWend
So, some sample output will be:
test text things look good![FSERR]: uh oh this file system is at 90% capacity!some more good looking text :)[WASERR]: oh no an app server is down!