>I was thinking it was either you or Borislav who help me before on this but this code sample does not look familiar. Is there a way to do it without the ado connection? How about the various formatting commands like borders, fonts, etc.?
My trick was to use the clipboard. See message #
1015959, or better the whole thread.
As for the niceties, I've found it was the simplest (not my invention, but I really liked it) to have a preformatted excel sheet with named ranges, and store the values into those ranges, then just SaveAs() wherever I want it.