Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Why you don't create a report with qlik? Whit this reports is not necessary to use macros.
Regards