Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Are you allowing System Access for your macros?
Are you allowing System Access for your macros?
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.
thks, for the Ctrl+Shift+M cause I give permisions into the macro, bút into the script
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?