Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Just record a macro for each feature and then look at the recorded vba code
Have tried that however not all of them work. Got most of them done that way