5 Replies Latest reply: May 4, 2015 10:31 AM by Shan Ahmed RSS

    Macro to Export a field from a table into a  .txt file from Qlikview document

    Shan Ahmed

      Hi All,

       

      I was trying to find a Macro example to Export field from a table into a  .txt file from Qlikview document when the Qlikview document resides in the accesspoint.

       

      I can save a .txt file in my local machine using the below macro But dont know how it works when the Document is deplyed to production. How the users can press a button and it will prompt to download a text file based on the selection of the users? Is it possible to achieve?

       

      Sub Export

      ActiveDocument.Sheets("SH02").Activate

      set obj = ActiveDocument.GetSheetObject("TB02")

      filepath="C:\test\test.txt" 

      obj.Export filepath,4

      ActiveDocument.GetApplication.Sleep 5000

      End Sub

       

      Can anyone help me with this?

       

      Thanks,

      Ahmed