The article was interesting, and the conversation it spawned:

Though I knew how to paste columns from SSMS, and I knew how to *automate* columns-inclusion using export tasks, what I did NOT know was how to *format* the Excel output.

Something I find especially interesting, from Phil's article:

--format the headings in Bold nicely

IF @hr=0

SELECT @strErrorMessage='formatting the column headings in bold ',

@objErrorObject=@objWorkSheet,

@command='Range("A1:'

+SUBSTRING(@alphabet,@currentColumn/26,1)

+SUBSTRING(@alphabet,@currentColumn % 26,1)

+'1'+'").font.bold'

IF @hr=0 EXEC @hr=sp_OASetProperty @objWorkSheet, @command, 1

(I'm leaving out the context, which you can get from Phil's article.)

And I can see it would be useful, for me, to be able to do this kind of Excel formatting from ADO/VBScript...

... so, Gosta, does your article include Excel *formatting* from VBScript? If so, by all means please share the link here, if & when your article is published.

Thanks, alll...