Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Export PDF

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

1 Solution

Accepted Solutions
jsn
Honored Contributor

Export PDF

Are you allowing System Access for your macros?

4 Replies
jsn
Honored Contributor

Export PDF

Are you allowing System Access for your macros?

Not applicable

Export PDF

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.

Not applicable

Export PDF

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

Not applicable

Re: Export PDF

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?

Community Browser