I'm in the middle of writing a program to generate a file. This file will be used to create a document in QDLS, which in turn will be FTPed elsewhere and become a .csv (and be opened using Excel). All of that is built. The issue I'm having is that, for some cells in the eventual Excel, I need a soft line feed character to divide the cell contents into two logical lines.
I assume I have to insert a control character -- but which one? I've tried \n, Chr(10), and the VB function vbLF all to no avail. Can someone help?
I assume I have to insert a control character -- but which one? I've tried \n, Chr(10), and the VB function vbLF all to no avail. Can someone help?
Comment