By formatting, I mean fonts, colors, cell outlines etc. A small sample of the Excel VBA looks like this:
' format title row
With Range(Cells(1, 1), Cells(1, xCols))
.Interior.ColorIndex = 15
.Interior.Pattern = xlSolid
.Font.Bold = True
.HorizontalAlignment = xlCenter
.VerticalAlignment = xlCenter
End With
'format revision titles
Rows("1:1").RowHeight = 95
With Range(Cells(1, 6), Cells(1, xCols))
.HorizontalAlignment = xlCenter
.VerticalAlignment = xlBottom
.Orientation = 90
.WrapText = True
.Font.Size = 8
End With
As I pointed out, this kind of stuff in Excel VBA is very verbose. It gets even worse running Excel code from acad because of the unqualified references problem in Office automation. ( see MS KB # 319832) That's why I want to run it native in Excel.