Macro to create PDF

[#1]

Hi,

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.

Regards,

KSP

Code

[Anonymous]

Hi All,

I am trying convert my report into .pdf format and save file onto my local machine.

My path: C:\Users\galir1\Desktop\PFG Analysis\Test_pdf.pdf

I used above path in below PDF Testv0.qvw but i don't see converted .pdf report in above folder.

Can any one of let us know how to use this.

[rohit214]

Hi Omid,

Even i am also getting the save dailog.

Thanks

Rohit