topic Re: VB Script Issue in creating WScript.Shell Object in QlikView

VB Script Issue in creating WScript.Shell Object

Wed, 17 Dec 2014 06:10:49 GMT

Hi,

i have downloaded a document regarding creating a PDF Report, In That there is Macro function which have below

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

Same i had copied the macro in my QV file as below

Function printReportPDF_NEW(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

But the downloaded document working fine , but in my document red marked line giving me error.

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

Kindly let me know why i am getting error in 1 document and not in other document.

Re: VB Script Issue in creating WScript.Shell Object

vikasmahajan — Wed, 17 Dec 2014 06:28:24 GMT

Check have you install free pdf printer and sample demo

Hope this helps you

Vikas

Re: VB Script Issue in creating WScript.Shell Object

Wed, 17 Dec 2014 06:35:27 GMT

Hi,

i had check the same code which u have attached , your code is not giving error while running, same code i copied from your document to my document and its showing me the error on this line

Set WSHShell = CreateObject("WScript.Shell")

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

Re: VB Script Issue in creating WScript.Shell Object

rwunderlich — Wed, 17 Dec 2014 06:35:45 GMT

This is usually due to the Module permissions. Open the Module Editor (Ctrl-m) and select "Allow System Access" in the Current Local Security dropdown.

-Rob

Re: VB Script Issue in creating WScript.Shell Object

Wed, 17 Dec 2014 06:38:48 GMT

Thanks Rob,

Its Working Now 🙂

Re: VB Script Issue in creating WScript.Shell Object

Wed, 17 Dec 2014 06:40:41 GMT

Hi Vikas,

For your example which PDF Creator Application u have used ?

Re: VB Script Issue in creating WScript.Shell Object

fabio182 — Tue, 09 Jan 2018 17:30:44 GMT

Hi Rob, I have a question

every time I run the macro I get a pop up where it tells me where I should store the file, there is some way to run the default route without having to pop up

Re: VB Script Issue in creating WScript.Shell Object

fabio182 — Tue, 09 Jan 2018 17:34:48 GMT

rwunderlich‌ please your support

Re: VB Script Issue in creating WScript.Shell Object

rwunderlich — Tue, 09 Jan 2018 19:17:42 GMT

Can you post the macro you are running?

-Rob

Re: VB Script Issue in creating WScript.Shell Object

fabio182 — Tue, 09 Jan 2018 19:29:19 GMT

This is macro

Re: VB Script Issue in creating WScript.Shell Object

rwunderlich — Tue, 09 Jan 2018 19:51:37 GMT

I don't think the QlikviewPDF printer is a supported option any more. You may want to try another PDF printer. Also, I suggest opening a new thread here for this question as you may get more responses that way, perhaps from someone still using the QlikvewPDF printer. I don't have it.

-Rob