>>I'll look at my old code. I'm pretty sure there is a way to do this with another
>>member function [formular1c1()?? can't remember].
>
>Not sure but I had to apply a full set of styles to define the sheet in the exact
>way I want. The previous version of my dataset to Excel was not doing much.
>This one format the headers, backgrounds, alignments, date formats and such.


I can't remember what I did. When I worked for a large manufacturing company, they used to print out schedules and what have you on a big plotter to hang on the walls for employees. Some of the uploading we did from our scheduler software into Excel used multi-line data formats, and I think I remember having a very similar issue. I was almost sure it was STRTRAN(data, CHR(10), SPACE(0)) (using only ASCII-13 characters) and something else that was unique, like o.formulaR1C1().

If I find that code I'll let you know. I remember at the time figuring out what to do by beginning to record a macro, doing the typing manually (with Shift+Enter), stopping the macro, and then looking at the VBA it created. I don't have Microsoft's Office on this computer (only LibreOffice) or I would try it right now. :-)