12 Comments

  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 ?
    Regards
    Sergio

  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?

    • Luca Jonathan Panett
      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

      Regards
      Luca Jonathan Panetta

      • Stefan Walther
        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 …

        Regards
        Stefan

4 Trackbacks

  1. By QlikCommunity | QlikTip #19: Suppressing Macro-Security (Module Security) Dialog on QlikView-Server/QlikView-Documents - The QlikView Blogroll on September 29, 2010 at 19:07

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

  2. By QlikCommunity | QlikTip #3: Check whether a field exists or not (translated and improved) - The QlikView Blogroll on October 7, 2010 at 10:19

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

  3. By QlikTip #1: Statusbox/Auswahlstatus in Excel-Export integrieren | qlikblog.at on March 18, 2011 at 13:49

    […] 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 ……