Discussion Board for collaboration on QlikView Scripting.
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.
I use PDF-XChange and the method should work in your case as well. Open 'Devices and Printers' in the windows Start menu. Look for QlikViewPdf in Printers and Faxes section. Right-click on the icon and select 'Printing Preferences'. Scan through the sections and you should find a place to change the 'Save' preferences. For example, in PDF-XChange, it is in 'Save' section.
you can use this code for printing pdf with qlikview PDF
ActiveDocument.PrintReport "RP02", "QlikViewPDF"
Set WSHShell = CreateObject("WScript.Shell")
WSHShell.RegWrite "HKCU\Software\QlikViewPDF\OutputFile", pdfOutputFile, "REG_SZ"
WSHShell.RegWrite "HKCU\Software\QlikViewPDF\BypassSaveAs", "1", "REG_SZ"
Set WSHShell = nothing
Thanks for your quik help. I tried creating PDF from the scratch through Bullzip. No Luck.
I am running on Windows 7 Professional 64bit. Perhaps Windows 7 64 bit is not allowing direct saving of PDF, without a SaveAs dialog capturing location and filename.
The code you have shared seemed to be working perfect. May I know which OS you are operating on?
Hi Omid Ebrahimi,
Thanks for sharing the doc. Appreciate. I copy pasted the script andd created same variables. Following are observed:
1. PDF printing still opens the SaveAs dialogue
2. In mail, I changed the port number to 25 (as advised by my hosting company). Mail script neither shows success nor error. This is weird.
If you can assist, it would be great. I am attaching my doc.
i check it
it work correctly with no saveas dialog
are you create qv folder in drive c?
and for second question
icant undrstand your problem can you explain it?