MS Notepad 256 character limitation 1

[Bass71]

Hi;

I'm finding that when an excel macro saves a comma delimited spreadsheet as a notepad file, anything more than 235 characters gets truncated and wrapped to the next line. Is there a line of code I can insert to make it 16 bit instead of 8 bit?

Thanks.............RO

 

[stravis]

Your code is fine. The output from your macro writes to the text file properly. It is notepad that reads and displays the information incorrectly. You should download a good text viewer/editor from an internet shareware/freeware site, so that you can view the comma delimited file correctly.