How to Script Macro to Format Excel Export

[#1]

I am trying to script a macro to format my excel document that I am exporting.

Where can I get some script on formatting, for example:

Center Align

COlour Cells

Draw Borders

etc

Rgds

[#2]

Why would you not format using the dialog boxes or design mode within qlikview? Is this a special need for additional formatting?

Also I would suggest having a module within excel to run the formatting you want after it has exported. QlikView from what I heard is eventually doing away with VB, but that might just be hearsay

Excel Marco Code - Record type VB

With Range("A1:C1")
    .HorizontalAlignment = xlCenter
    .Font.Italic = True
    .Font.Bold = True
    .EntireColumn.ColumnWidth = 15
End With

[m_woolf]

Just record a macro for each feature and then look at the recorded vba code

[#4]

Have tried that however not all of them work. Got most of them done that way