Is it Notepad, or me?

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....

[Steve Hartman]

1. open the file in Wordpad instead of notepad.

2.In notepad choose FORMAT and click on Word Wrap

[charlie79]

1. I realize that is an option. But, it's a matter of convenience. When the file is double-clicked, it's going to open in Notepad and not Wordpad, and there are going to be numerous people opening this log file.

2. Word wrap is on.

[Steve Hartman]

Could you post the code you're using to create the log file?

[charlie79]

Thanks for your help! I figured it out, I needed to be using vbCrLf instead of just vbCr! Duh..

[Steve Hartman]

I'ld say you're welcome if I'ld done anything to help!

[Mark W.]

On 2002-03-12 12:36, charlie79 wrote:
Thanks for your help! I figured it out, I needed to be using vbCrLf instead of just vbCr! Duh..

[img]/board/images/smiles/icon_smile.gif[/img]

I wondered about that... using CHAR(10) instead... but, you seemed pretty adament about using CHAR(13).