topic Re: Export PDF in QlikView

Export PDF

Wed, 22 Jun 2011 09:38:34 GMT

Hi all,

this is my macro:

sub printRP01

printReportPDF "C:\Users\Public\Documents\TestQlik\PreviousPeek\Test\18T.pdf"

ActiveDocument.GetApplication.Sleep 2000

ActiveDocument.PrintReport "RP02", "QlikviewPDF"

ActiveDocument.GetApplication.Sleep 10000

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

at the second line (printReportPDF "C:\Users\Public\Documents\TestQlik\PreviousPeek\Test\18T.pdf") i've this error:

ActiveX component can't create object: 'WScript.Shell'

I use QlikView 10 SR2 64bit and i've installed PDFCreator 1.2.1

Export PDF

Anonymous — Thu, 23 Jun 2011 00:24:21 GMT

Are you allowing System Access for your macros?

Export PDF

Thu, 23 Jun 2011 06:43:04 GMT

thx Johannes! How you suggest i allowed System Access for macros with ctrl+shift+M and now it works... but files pdf aren't store in directory. I check and the path where i want to save exists on my machine. I set even the UAC (User Access Control) on my windows 7.

Another question is how i can automate in qlik System Access for macros, because when i close and then restart qlik i have to allow System Access again.

Export PDF

Fri, 14 Oct 2011 19:07:20 GMT

thks, for the Ctrl+Shift+M cause I give permisions into the macro, bút into the script

Re: Export PDF

Fri, 20 Jul 2012 01:49:26 GMT

hi s.fiemazzo

i tested your example. and all the same i tested, stop at this line, and no error info bake to me

ActiveDocument.PrintReport "reportID", "QlikviewPDF",false

is there any thing i need set before?