G
Guest
Guest
I'm am writing to a text file, called testfile.log through VBA in an excel app (XL2000). I am writing the current Date and Time to the file, and trying to put a carriage return at the end of each entry. I have tried using "vbCR", as well as Chr(13). The thing of it is, when I open the log file in Notepad, I get little rectangle characters were the carriage return is supposed to be. I realize this is an actual carriage return character, but I want it to do a carriage return. I've tried changing the way I open the file, ASCII, Unicode, etc.. that doesn't seem to work either. Also, if I open the log file with wordpad, it looks right. Please help....