topic VBscript error: Object required: 'WScript' in QlikView

VBscript error: Object required: 'WScript'

Wed, 01 Sep 2010 12:01:51 GMT

Hi,

I have a macro that exports an object to a CSV file.

I would like to display a message when the export starts and one when it is done. The first message should not require the user to click ok. So msgbox is not an option.

From the net I plucked this:
Dim WshShell, BtnCode
Set WshShell = WScript.CreateObject("WScript.Shell")

BtnCode = WshShell.Popup("Export started", 10)

The macro doesn't work:

Object required: 'WScript'

Note: security is set to System Access and Allow System Access.

QV 8.5

Any suggestions?

Thanks

Anton

VBscript error: Object required: 'WScript'

llauses243 — Wed, 01 Sep 2010 12:17:31 GMT

Hi,

i not use wscript. and funct

good luck, Luis

VBscript error: Object required: 'WScript'

Wed, 01 Sep 2010 13:24:37 GMT

Hi Luis,

Thanks. Now I get the pop-up, but it is waiting for the user to click ok. I does not go away after 10 seconds as it should...

Anton

VBscript error: Object required: 'WScript'

Sun, 12 Sep 2010 12:29:21 GMT

Hi all,

No solution yet...

Does anyone know of a way to show a message during the execution of a macro that does not require any action from the user?

In other words: showing a message that does not interupt the macro execution?

Thanks

Anton

Re: VBscript error: Object required: 'WScript'

pljsoftware — Mon, 11 Apr 2011 14:23:54 GMT

Hello Anton,

I had the same problem and I solved it by removing the word WScript before CreateObject


'Correct
Set WshShell = CreateObject("WScript.Shell")
Set oExec = WshShell.Exec("calc.exe")
'NOT Correct
Set WshShell = WScript. CreateObject("WScript.Shell")
Set oExec = WshShell.Exec("calc.exe")

Regards

Luca Jonathan Panetta

PLJ Software

Re: VBscript error: Object required: 'WScript'

azimabadi — Wed, 08 Aug 2012 13:31:03 GMT

Thank you Luca,

this helped me so much!

Regards

Peyman

Re: VBscript error: Object required: 'WScript'

azimabadi — Mon, 27 Aug 2012 14:31:52 GMT

can i close this application(i.e. calc.exe) from my script too?

Best Regards

Peyman

Re: VBscript error: Object required: 'WScript'

pljsoftware — Sun, 02 Sep 2012 00:05:55 GMT

Hi Peyman,

look these

http://ss64.com/vb/exec.html

http://www.excelforum.com/excel-programming-vba-macros/480065-how-to-close-an-application.html

But NOTE that the use of Terminate can generate memory leaks.

Regards

Luca Jonathan Panetta

PLJ Software

Re: VBscript error: Object required: 'WScript'

Thu, 16 Feb 2017 02:17:19 GMT

was there a solution to this?

Re: VBscript error: Object required: 'WScript'

petter — Thu, 16 Feb 2017 02:58:30 GMT

A tiny modification of the script he found on the internet will make it work in a Module/Macro/VBScript in QlikView:

If you leave out WScript in front of the CreateObject() it will work.

Furthermore you have to change these two settings from safe mode in the Edit Module Editor:

Requested Module Security: System Access

Current Local Security: Allow System Access

The code should be wrapped in a sub routine to:

BTW: The timeout that is supposed to work is a bug in the WShell component in Windows. Has nothing to do with QlikView. So putting a value for timeout like 10 seconds will never work... You will have to press a button.

Re: VBscript error: Object required: 'WScript'

petter — Thu, 16 Feb 2017 03:08:04 GMT

By doing this it will also work with timeout: