1. Sergio
    Posted August 6, 2010 at 12:19 | Permalink

    Dear Stefan,

    I write in english ’cause Ich spreche wenig Deutsch.
    That’s fine, but what’s about the need to have something more ?
    I mean is there any macro example or reference to create your own excel from a trigger ?

    Common is the formatted reporting created in excel.
    So it’s easy to extract a table selection to Excel
    (eg :

    dim o
    Set o = ActiveDocument.GetSheetObject(objectId)
    o.ExportBiff filePath


    But what about the possibility to extract several tables and formatting it as u want in excel ?

    Have u never faced with this kind of request ?

  2. Dinesh Sharma
    Posted February 8, 2011 at 20:02 | Permalink

    thanks much for sharing :)

  3. gerhard
    Posted June 1, 2011 at 09:52 | Permalink

    Da sieht man wieder mal, wie sehr scheinbare Kleinigkeiten das Leben erleichtern können! Genau diese Funktionalität stand schon lange auf der Wunschliste unserer User!
    Danke und lg :-)

  4. sneha
    Posted July 12, 2012 at 08:50 | Permalink

    its not working on monthand year list boxes may i know the solution for that?

    • Posted July 26, 2012 at 16:22 | Permalink

      Hi Stefan,

      there is an other solution directly in macro

      	set userProp = ActiveDocument.GetApplication.GetUserPreferences
      	userProp.SelectionStampInBIFFExport = true
      	ActiveDocument.GetApplication.SetUserPreferences userProp

      Luca Jonathan Panetta

      • Posted August 21, 2012 at 10:15 | Permalink

        Thanks for sharing!

        Sure you can also use this macro, but this requires that the user uses QlikView Desktop or IE-Plugin and execution of this macro is necessary all the time.
        My above mentioned solution will force this setting due to a global setting on the current machine …

        So just decide which solution better fits your needs …


4 Trackbacks

  1. […] QlikTip #1: Transferring Current Selections to Excel-Export (translated) […]

  2. […] QlikTip #1: Transferring Current Selections to Excel-Export (translated) […]

  3. […] wurden, ideal wäre ein gleichzeitiger Export der Auswahlbox nach Excel.Note: There is also an english version of this article available …Diese Funktionalität steht in QlikView zur Verfügung, wenngleich diese in den […]

  4. By Hotaru CMS on December 19, 2012 at 05:28

    QlikTip #1: Transferring Current Selections to Excel-Export (translated)…

    A person these kinds of leveling tactic is by concentrating on questing. It delivers shut to 24 professions, however only four are offered from the start out. You will also have to have to decide on ……