21 Replies Latest reply: Dec 4, 2014 6:38 AM by rohit gupta RSS

    Macro to create PDF



      I have gone through the interesting discussion " Macro to export AND mail report as PDF"  by different authors in the discussion started by in October 2010 by JochenAndries  (using Bullzip PDF). Em Vau suggested in Februaru 2012 to use QlikViewPDF. Thanks to both and others contributed on the same discussion. Excellent automation tips!


      I have used QlikVewPDF.  I have combined sub code and function code for simplicity. The code works fine but  QlikViewPDF printer dialogue opens, which should not. The PDF file should be saved automatically.


      I am attaching  image of code, image of  saveas dialog and the QVW document.


      Kindly suggest how we can avoid the SaveAs dialog.