Hi Barry, Why don't you do a macro in excel that will do the Format/row/autofit and let your users have it?
Louie -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Barry Brevik Sent: 20 October 2005 20:05 To: U2-users (E-mail) Subject: [U2] [UV][OT]Embed command in CSV file? A little off-topic... >From universe, I am creating a sequential file which is formatted as a CSV file, in other words each field is quoted and separated from each other by commas, for example: "John","Jacob","Dingleheimer Schmidt" The intent is that the resulting file is opened with Excel. You can force any cell into multiple lines by embedding a CHAR(10), for example: WRITESEQ \"John","Jacob","Dingleheimer\:CHAR(10):\Schmidt"\ TO MY.CSV.FILE THEN NULL ...when viewed in Excel will give you... John Jacob Dingleheimer Schmidt ...which is a great way of expressing multi-values. Finally I arrive at the crux. When you open such a document in Excel, it only displays one line per row even if a cell in that row contains multiple lines. To see all lines you have to select all and hit FORMAT | ROW | AUTOFIT. My users seem to be incapable of dealing with that, so... ...does anyone know if it is possible to embed some kind of command in a CSV file that will get Excel to autofit those rows automatically? Barry Brevik ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
