topic Re: SaveAs pop up issue in QlikView

SaveAs pop up issue

rohit214 — Fri, 05 Dec 2014 09:47:44 GMT

Hi all,

I am generating 2 reports through macro its working fine. but i am always getting the Save As pop up.

which is i don't want, so please guide me how to remove that pop up and replace exsisting file without permission in a perticular

folder. I have Adobe Acrobat X standard for generating my PDF .

My Macro for generating the Reports

sub printRP01

printReportPDF "C:\Users\rgupta27\Desktop\New folder\DWR.pdf"

ActiveDocument.GetApplication.Sleep 2000

ActiveDocument.PrintReport "RP01", "QlikViewPDF"

ActiveDocument.PrintReport "RP02", "DWR"

ActiveDocument.GetApplication.Sleep 10000

ActiveDocument.PrintReport pdfOutputFile, "QlikViewPDF", True

end sub

Function printReportPDF(pdfOutputFile)

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

End function

Thanks

Rohit

Re: SaveAs pop up issue

rohit214 — Fri, 05 Dec 2014 10:12:59 GMT

any one have any idea plz share

Re: SaveAs pop up issue

marcus_sommer — Fri, 05 Dec 2014 10:38:49 GMT

This is code for the old qv-pdf-printer and you need to install these pdf-tool. If it's installed you need to set it as default printer before you print, maybe dynamically per code like this:

if WshShell.RegRead ("HKCU\Software\Microsoft\Windows NT\CurrentVersion\Windows\Device") <> "QlikViewPDF" Then
WSHShell.RegWrite "HKCU\Software\Microsoft\Windows NT\CurrentVersion\Windows\Device", "QlikViewPDF", "REG_SZ"
end if

By use from other print-tools you will need other code to set the appropriate settings. You will find hints for these here within the community and per google:

Re: Supress "Open document" Bullzip PDF printer

Re: generate pdf with Xchange

- Marcus

Re: SaveAs pop up issue

rohit214 — Fri, 05 Dec 2014 11:42:06 GMT

Hi,

Thanks for the reply but i can't install other software in production enviourment.

I have Adobe Acrobat, so please suggent me how to get rid out from this issue.

Regards

Rohit

Re: SaveAs pop up issue

marcus_sommer — Fri, 05 Dec 2014 11:56:33 GMT

https://forums.adobe.com/thread/746789?tstart=0

- Marcus

Re: SaveAs pop up issue

rohit214 — Fri, 05 Dec 2014 12:46:34 GMT

this link doesn't help me...

Re: SaveAs pop up issue

marcus_sommer — Fri, 05 Dec 2014 14:32:16 GMT

You will need some own efforts ...

- Marcus