QlikViewPDF Macro not working

mandz147 — Thu, 20 Jul 2017 07:53:39 GMT

Hi,

I have recently had to get a new computer and now I have a problem that none of my QlikViewPDF macros are working. I have tried changing the pdf printer to Bullzip, PDF X-CHange and Cute PDF but still nothing works, it runs the macro but does not save the file to the location. Is there something that I am missing or need to change? It all works fine on my old machine but just can't get this resolved on my new machine.

Macro for export is as follows, which has not changed from previous:

FUNCTION printReportPDF(reportID, pdfOutputFile)

Set WSHNetwork = CreateObject("WScript.Network")

Set WSHShell = CreateObject("WScript.Shell")

WSHNetwork.SetDefaultPrinter "QlikViewPDF"

WSHShell.RegWrite "HKCU\Software\QlikViewPDF\OutputFile", pdfOutputFile, "REG_SZ"

WSHShell.RegWrite "HKCU\Software\QlikViewPDF\BypassSaveAs", "1", "REG_SZ"

ActiveDocument.PrintDocReport reportID

ActiveDocument.GetApplication.Sleep 5000

set WSHShell = nothing

END FUNCTION

Please can someone help I am desperate as I have hundreds of reports I do monthly

Re: QlikViewPDF Macro not working

jmvilaplanap — Thu, 20 Jul 2017 14:22:15 GMT

Hi,

Why you don't create a report with qlik? Whit this reports is not necessary to use macros.

Regards

topic Re: QlikViewPDF Macro not working in QlikView

QlikViewPDF Macro not working

Re: QlikViewPDF Macro not working