topic Re: How to Script Macro to Format Excel Export in QlikView

How to Script Macro to Format Excel Export

Wed, 17 Apr 2013 11:54:00 GMT

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

Re: How to Script Macro to Format Excel Export

Wed, 17 Apr 2013 12:45:53 GMT

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

Re: How to Script Macro to Format Excel Export

m_woolf — Wed, 17 Apr 2013 13:35:02 GMT

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

Re: How to Script Macro to Format Excel Export

Thu, 18 Apr 2013 04:46:43 GMT

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