Discussion Board for collaboration on QlikView Scripting.
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:
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 = 15End 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