Hi, I'm using VB6, creating reports using Excel object, eg:

Code:
 Set xlOut = CreateObject("Excel.Application")
 With xlOut
      .DisplayAlerts = False
      .Workbooks.Open "C:\Data\T1L.xls"
      .Worksheets(1).Name = "SUN101_" & BatchNo
      For ColLoop = 0 To 13
       .Columns(ColLoop + 2).ColumnWidth = ColWidths(ColLoop)
      Next ColLoop

etc. etc.
But it's so dreadfully slow - anyone know:

1. Why?

2. How can I speed things up withough dumping Excel.

And before anyone says "Yes, but why are you using Excel", it's so easy to populate, save, view, print and all that jazz. And I suppose you'll say, well, speed is the price you pay for all that convenience. And I'll go and cry in a corner or something. And I'm not even a girl...